S A U | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Post Type Selectors
Answers
Questions
Posted an answer
Quadrant axis

Hey, Denis. I've simulated the solution to your problem with a combination of three components: * * The first component is a bubble plot with X-, Y-axes off; the second one is for the X-axis with the...

September 22, 20235
Posted an answer
reference matrix name in a formula

Hi all, Here is a solution to the problem with using the ConcatLists() function and $MatrixName: * * Good luck

August 19, 20235
Posted an answer
reference matrix name in a formula

Hi all! Here is a solution to the problem without using the Selectlist() function: * * Good luck

July 15, 20235
Posted an answer
sum(summary()) for groups with varying number of items

Hi lyledp, try that scalable model structure, plz. * * where M1:: flat table (your source data); M3:: year allocation using the constrain input by means of Ctg M2::Years; M2:: sum report with a single...

July 3, 20235
Received an upvote
May 16, 202310
Received an upvote
May 15, 202310
Posted an answer
Need Copy/Paste Script down to a specific Item Level, example Copy / Paste 2024 data only.

Hi CurtisHirata, your problem can be solved by means of A-script like this: * * Here is a result: * * Good luck

May 12, 20235
Received an upvote
May 11, 202310
Posted an answer
Header and footers in page setup: can I remove the border

Luca, hello! If you haven't solved the problem yet, here are my two strategies for solving it in order of increasing solution time. 1. Open your QM model file in the Windows version of QM. For this purpose...

March 9, 20235
Received an upvote
March 8, 202310
Answer was selected as best
February 9, 202310
Posted an answer
Sum of items: Get sum of all items to calculate one item

Hi Gilbert, try this formula, plz.: * * Good luck.

February 8, 20235
Posted an answer
Setting a cell to a fixed value

Provided, you do not force QM recalculate a model, it can be used this formula to insert record's Date and Time Stamps:

January 29, 20235
Posted an answer
Models saved in v22.2 backwards compatible?

Hi all, Interesting. Provided that the QM22.1.2 license is valid, what prevents users from upgrading to QM22.2.0? In any case, users have the option to install QM22.2.0 to a new folder. Good luck, SAU.

January 9, 20235
Posted an answer
Data slices in the QM

FYI. Starting from version 2022.2.0, the use of new QM's feature - check-boxed boolean constrained input - will allow you not to use canvas switches. Slicers become fully scalable without any manual manipulation...

November 25, 20225
Posted an answer
Why do I need a Helper when I know the Item?

Gilbert, glad I was able to help you! Good luck

November 18, 20225
Posted an answer
Why do I need a Helper when I know the Item?

Gilbert, let’s explicitly specify the third parameter of select() function (#true#): * * * Hope the formulas will be workable in this case. Good luck

November 18, 20225
Posted an answer
Why do I need a Helper when I know the Item?

Gilbert, both formulas are working, as indicated by green check marks in upper left corners of the pictures. Good luck

November 18, 20225
Received an upvote
November 17, 202210
Posted an answer
Why do I need a Helper when I know the Item?

Gilbert, try another formula version, plz: * * It looks like a Mac version of QM doesn't recognize such formula syntax's. These two formulas are complete equivalents. The first one is just shorter. 1....

November 17, 20225
Load More