lerzegov | Answers

Generic selectors
Exact matches only
Search title only
Search in content
Answers
Questions

Hi Walker, please find in the attachment a revised version of your model a formula for doing the lookup on two dimensions. I went for "using as", because it gives a cleaner formula, making good use of...

View Question
1 Vote Selected

Hi S A U, I reproduced a very simple use case in the model linked here (could not attach it to the post, error "file type not allowed"). Please delete the year category in the P/L matrix => deleted...

View Question
0 Votes

Hi S a u, you improved a lot on my example both in the formulas and the presentation! Thanks for the very useful tips on chart formatting. Kind regards, Luca

View Question
0 Votes

I have encountered the same problem as Carlo: in QM 5.1 Mac Osx, when printing a view, one loses format information, starting from font sizes different from the default. That's a big waste of time for...

View Question
0 Votes

Why don't you import the merged data into the 3rd matrix directly from the database via datalink? If both queries have the same structure, you can import both with a SQL statement [1st query] UNION [2nd...

View Question
0 Votes

Thanks, Ben, for your informative answer. From an end user's point of view, I cannot grasp the relevance of the "sandboxing" choice. In traditional spreadsheets, scripting allows one to do many things...

View Question
0 Votes

Mike - As far as I can understand, the issue may involves some complex technical aspects. In order to focus, I have a question for your colleague: how could a script suppress the use of paginated data...

View Question
0 Votes

Janak: the scripting API has a Model class and a Quantrix class which provides more than adequate functionality for creating, saving and switching between models. In another post, I pointed to the fact...

View Question
0 Votes

Hi Mike. I share J Scott's view. Checking problems may slow down recalculation, data import AND script execution when there is some innocuous imperfection in a model. I enclose a model with a script named...

View Question
0 Votes

Hi Mike. I share J Scott's view. Checking problems may slow down recalculation, data import AND script execution when there is some innocuous imperfection in a model. I enclose a model with a script named...

View Question
0 Votes
Load more answers