lerzegov | Answers

Generic selectors
Exact matches only
Search title only
Search in content
Post Type Selectors
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

I am glad to report that the missing check mark issue referenced as the first point in my previous post in this thread is no longer there after upgrading OSX to Monterey 12.3.1. Such issue had been showing...

View Question
0 Votes

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
Load more answers