jlin | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
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 27, 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 27, 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 27, 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 27, 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
October 29, 201810
Received an upvote
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
Posted an answer
Scenario table like in Excel

I think your question about doing Excel-like sensitivity analysis may be addressed by the new Solver feature... I wouldn't know as I haven't used it yet. However, if you set up your scenarios such that...

October 23, 20185
Posted an answer
What options are available in 2018 to read data from Excel files on Mac? On Windows?

Oh, and converting and maintaining the Excel file as a CSV is not an option. I would like the Excel file to preserve formatting, multiple sheets, etc.

October 4, 20185
Asked a question
What options are available in 2018 to read data from Excel files on Mac? On Windows?

What vendors/options are there for integrating Excel files as Data Sources to read/push data from Quantrix? The closest JDBC driver solutions I've found still seem overkill; certainly the price is considering...

October 4, 20182
Posted an answer
Soft Recurrence as an arguments of the Min()

I logged an IDBS case in 2016 and after 19 months of silence was finally told of a workaround for this bug. It's a hack, but it works. I'm posting it here publicly in case anyone else runs into this problem....

July 7, 20185
Load More