| Posted an answer Quadrant axisHey, 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, 2023 | 5 |
| Posted an answer reference matrix name in a formulaHi all, Here is a solution to the problem with using the ConcatLists() function and $MatrixName: * * Good luck | August 19, 2023 | 5 |
| Posted an answer reference matrix name in a formulaHi all! Here is a solution to the problem without using the Selectlist() function: * * Good luck | July 15, 2023 | 5 |
| Posted an answer sum(summary()) for groups with varying number of itemsHi 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, 2023 | 5 |
| Received an upvote | May 16, 2023 | 10 |
| Received an upvote | May 15, 2023 | 10 |
| 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, 2023 | 5 |
| Received an upvote | May 11, 2023 | 10 |
| Posted an answer Header and footers in page setup: can I remove the borderLuca, 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, 2023 | 5 |
| Received an upvote | March 8, 2023 | 10 |
| Answer was selected as best | February 9, 2023 | 10 |
| Posted an answer Sum of items: Get sum of all items to calculate one itemHi Gilbert, try this formula, plz.: * * Good luck. | February 8, 2023 | 5 |
| Posted an answer Setting a cell to a fixed valueProvided, you do not force QM recalculate a model, it can be used this formula to insert record's Date and Time Stamps: | January 29, 2023 | 5 |
| 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, 2023 | 5 |
| Posted an answer Data slices in the QMFYI. 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, 2022 | 5 |
| 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, 2022 | 5 |
| 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, 2022 | 5 |
| 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, 2022 | 5 |
| Received an upvote | November 17, 2022 | 10 |
| 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, 2022 | 5 |