Gilbert | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Post Type Selectors
Answers
Questions

Welcome to the Quantrix Answers Community! This is a place for Quantrix users from around the world to share their questions, knowledge, and ideas. If you are posting a question, please include any accompanying information that might be useful to the reader (for example, a demo model or screenshot). Do not include any confidential information in your posts and remember that model attachments must be zipped. If your question is answered, please provide feedback! Providing feedback can help future users understand what’s worked. Thank you for being part of the Quantrix Community!

Please Note: A Quantrix team member will review new questions before publishing to the public. We hope this will reduce unwanted posts on our site.

Commented on a post

Tahir, Again, cool demonstration of what cell filters can do. I assume that Andy WANTS to use script, to force a certain look on the matrix. But also your solutions is able to be scripted: just set the...

May 11, 20242
Commented on a post

Thank you Tahir, I think this is a excellent suggestion! Thank you! I'm also using this on canvases. Still, the expression in the category filter I'm asking for is for "quick-and-dirty-on-the-fly" during...

May 9, 20242
Commented on a post

P.S.: Are you aware of the Idea portal, where you can post enhancement requests? https://quantrix.com/answers/questions/categories/idea-portal/

May 9, 20242
Commented on a post

P.S.: Are you aware of the Idea portal, where you can post enhancement requests? https://quantrix.com/answers/questions/categories/idea-portal/

May 9, 20242
Posted an answer
Filtering a Category via Scripting

Hi Andy, I think category filters are not accessible by script, unfortunately. (As a lot of other interesting features are not, it just seems that most people do not use scripting, so incentive to further...

May 9, 20245
Asked a question
Parallel calculation on single formula

Hi, I'm having big models, running for several hours to calculate. Obviously I run these models on big computers with multiple CPUs. Unfortunately, depending on the model, all these nice CPUs are hardly...

May 9, 20242
Asked a question
Calculation engin: consider "Acknowledge Circular Reference" in calculation engin.

Hi, Basically, circular references are bad for the clarity of the model and bad for performence, and thus should be avoided where possible. But there are cases, where the calculation is inherently circular,...

May 9, 20242
Asked a question
Dynamic lists should work, also in models containing a circular reference

Hi, Currently, the input constraint "Dynamic Lists" if based on a calculated range does not work if the model contains a circular reference. I talk about the case when the Dynamic List calculation is...

May 9, 20242
Asked a question
Allow for expressions in Item Filter

Hi, Dynamic item filtering on categories is a relatively new feature, which can be especially powerful to display results or configure charts to focus on what you want to look at. The trouble is, in...

May 9, 20242
Commented on a post

Dear S A U, thank you for your valuable comments. I think your suggestion of using a "Group-Descriptor" instead of grouping is a very important one, as it helps to overcome the shortcoming of not being...

April 27, 20242
Posted an answer
Meditation on timelines

Re - Automatic update of Timelines: For the ones using the Timeline - Feature (Solution 3), I found a workaround for automatically define the Year-Range of timelines. While it is true that the properties...

April 27, 20245
Posted an answer
List all matrices in a folder

Hi, I'm just struggeling with a similar problem, wanting to create matrices in a folder structure by script. And yes, it's not possible to read/write the folder structure, or create folders and the like...

April 27, 20245
Posted an answer
Fomulate sum

Please lookup the documentation of the SELECT statement. It's the most powerful function in Quantrix, and needs some time to understand. What is very important to see is the difference between CATEGORIES...

April 17, 20245
Received an upvote
April 17, 202410
Posted an answer
Fomulate sum

Hi Marie, Not sure if I understand right, but this might do what you want? Gilbert

April 16, 20245
Posted an answer
csv format on export via scripting

Hi Robert, It seems that the property "Export formatted numbers" can not be set via script. I think this is a reasonable feature request to send to Quantrix. As I workaround, I suggest to manually format...

April 16, 20245
Posted an answer
Fix error using as

Thanks for your additional information. Unfortunately, I still do not understand. Can you send an example model, please? I do not see "Input" in your screenshot. Is there are reason for these very strange...

April 11, 20245
Posted an answer
Fix error using as

Hi Marie, It would be easier to help you, if you send an example model, or at least a screen shot. From the little information available, I conclude that you have two matrices, Matrix1 and Matrix2, and...

April 8, 20245
Posted an answer
Meditation on timelines

Dear S A U, Thank you very much for your input! I like your alternative formulas to the ones I suggested. They might be somewhat easier to understand and maintain. I think it's a valid suggestion to improve...

April 2, 20245
Asked a question
Meditation on timelines

Hello all, I\'m often hesitating which strategy to adopt for timelines in my model. I'm currently working on a big planning model, which contains Actuals, Budget, Short Term Plan, and Long Term Plan....

March 21, 20242
Load More