jlin | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Post Type Selectors
Answers
Questions
Received an upvote
March 25, 202110
Received an upvote
March 25, 202110
Received an upvote
March 25, 202110
Commented on a post

Just curious - would you advise users to generally avoid using summary items in their details matrix, period? As in, no Sum of Month & Sum of Years in timelines, etc.,? It seems like a waste of a core...

July 20, 20202
Commented on a post

Rich, regarding avoiding summary items - is it for the reasons you & I have discussed before, their usability problems when combined with e.g. valueat() and timeline? Or are there other reasons you...

July 20, 20202
Posted an answer
Replacing ‘Item Names’ with ‘Dynamic List’ for the Generate Items module

I would like to add that "Item Names" has its use; however the current implementation is very flawed, in that the generated items loses all grouping structure. I would propose that the Generate Items feature...

June 15, 20195
Posted an answer
Improving the readability of formulas through the formula’s variables

Sau, The image of your sample code - how are you getting Quantrix to display the formulas in this way (with dark background)? It's very nice on the eyes!

June 15, 20195
Posted an answer
Improving the readability of formulas through the formula’s variables

You have my vote, Sau. Although syntactically I think putting the variable definitions near the front of the formula (after any "In ... " statement, but before the item name whose value is being set)...

March 22, 20195
Posted an answer
Is there any way to get user role (not user name)?

If I understand Tahir correctly, he believes it would be easier to maintain a model where a single one matrix presents differently (w/ rows & columns filtered depending on user role) versus creating...

March 7, 20195
Posted an answer
Is there any way to get user role (not user name)?

If I understand correctly, Tahir may have in one matrix (or table view) some sensitive information that should only be shown depending on user role. He desires to use a filter expression that filters rows...

March 7, 20195
Asked a question
Any way to access and set properties of Canvas elements?

Would it be possible to set properties such as width, height, hidden etc. for elements of a Canvas? It doesn't seem like the object model allows any access. What I would like to do is add some Actions...

March 7, 20192
Posted an answer
DataNAV: Please clarify the differences between “Update items” vs “Refresh” vs “Refresh All”

Thank you Mike. The extra explanation helps!

December 15, 20185
Posted an answer
Script Nested Loop – Data Table in excel

Is this what you want? A single formula will do it.

December 15, 20185
Asked a question
DataNAV error when trying to add one DataNAV category into a matrix with another DataNAV category

What does this error mean? "Category XXXX references a field that is not compatible with the data source defined in matrix YYYYY " I have an XML data source containing multiple objects such as Employees,...

December 15, 20182
Asked a question
DataNAV: Please clarify the differences between "Update items" vs "Refresh" vs "Refresh All"

I manually edited the name of a item that was brought over from an XML Data Source via DataNAV, and also changed a value that was brought over via DataNAV. If I right-click on the Category tile and choose...

November 28, 20182
Asked a question
Manually added items to a category generated by DataNAV - how to manage?

I'd like to be able to better differentiate between items in a category populated by DataNAV vs ones I manually add/modify, including Summary items. I don't see any way of "locking down" a DataNAV category...

November 28, 20182
Posted an answer
Timeline recursion does not skip summaries

FYI if you have the need to do different offsets simultaneously, I would suggest calculating a single index value (that ignores all summary items). That way can support multiple, differently offset data...

November 28, 20185
Posted an answer
Any way to automatically update Item Names based on criteria?

I am in fact already using Item Generation extensively! I end up having an input matrix with category DepartmentsInput and DepartmentsInfo, use Generate Items to populate items for a second Category Departments...

November 28, 20185
Asked a question
Any way to automatically update Item Names based on criteria?

I'd like to keep the Item Names of Category A synced to match the value of a particular Item from Category B. I tried making converting Category A into a Primary Key and I can make it work once, but any...

November 23, 20182
Answer was selected as best
Group in a Matrix

You can't. You've already grouped A into 2, and B into 1. If you want to group A and B you'd have to remove groups 2 & 1 first.

October 29, 201810
Load More