S A U | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Answers
Questions
Received an upvote
April 6, 202110
Posted an answer
How to sum a value range with more than one criteria

Hi vb67! 1. Let there are three matrices: SD{C:Fields[I:Value, TypeP, P], C:Recs[I:Rc1..Rc10]} is some Source Data, SmlCrt{C:Criterium[I:TypeP, P]} is Sampling Criteria, Report{C:CalcVar[I:Calc1..Calc3]}...

April 2, 20215
Received an upvote
March 29, 202110
Received an upvote
March 29, 202110
Posted an answer
Useful improvements of rank() function

The problem solution is here. Good luck

March 26, 20215
Posted an answer
Three rank types calculation in QM

Here I am submitting unsorted data. As you can see, the calculations are correct in this case as well. * * Logic: * * *** Good luck

March 26, 20215
Asked a question
Three rank types calculation in QM

Hello everyone! Again, for those who appreciate the effectiveness of calculations in QM, I will show here a way to obtain three types of rank on sorted data (Useful improvements of rank() function). *...

March 26, 20212
Received an upvote
'Drop down menu' and number formats of binding cells

'Drop down menu' canvas's widget does not get number formats from the binding cells. This makes it impossible to use the 'Drop down menu' for error-free control of the model. I remember, QM4.1 easily took...

March 25, 202110
Received an upvote
Improving the readability of formulas through the formula’s variables

Tahir, the formula’s variables should be an optional feature, despite the fact that in the second picture it is written "AS IT SHOULD BE". Who wants to and to whom it is convenient, he will use the formula’s...

March 25, 202110
Received an upvote
Improving the readability of formulas through the formula’s variables

Addition. Here's how you could write this complicated formula using the formula's variables: * * I suggest to everyone to evaluate.

March 25, 202110
Received an upvote
Improving the readability of formulas through the formula's variables

If Subx team enter such an object as formula's variables in the QM, then the formulas will become much easier to write and read. For example, it could be implemented like this. The formula editor will...

March 25, 202110
Received an upvote
Improving the readability of formulas through the formula’s variables

Jlin, it would be interesting to look at your version of a possible implementation. Make a picture with your version of the above formula, we all compare the pros and cons of the two sentences.

March 25, 202110
Received an upvote
Improving the readability of formulas through the formula’s variables

FYI, Microsoft introduced similar functionality for Excel 2019 by means of the Let() function... But Subx development team within 1.5 years did not even respond to this offer. Excellent

March 25, 202110
Received an upvote
Improving the readability of formulas through the formula’s variables

jlin, In November 2015 I had requested Subx by email an option to set the formulas background color for QM6... Now it is already released QM8... So, for the reporting purposes i'm using 3rd party app converts...

March 25, 202110
Received an upvote
Improving the readability of formulas through the formula’s variables

For the exhibition only. See how clear the logic of the formula using the formula's variable is compared to the regular one. * * Is there anyone having an opinion on the topic? Or your models don't have...

March 25, 202110
Received an upvote
Replacing 'Item Names' with 'Dynamic List' for the Generate Items module

Hi, Subx team. It would be reasonable for you to replace the Item Names option in the Generate Items module with a similar Dynamic List option of the Constrain Input module. For what? - In order to generate...

March 25, 202110
Received an upvote
Wrong calendar calculations

The important addition. Calendar calculations were correct up to QM4.x.y. I am sure that the error was introduced due to the TimeLine module starting from QM5.x.y.

March 25, 202110
Received an upvote
Wrong calendar calculations

As is well known, the first week of 1900's date system is: * 1 = Sun; 2 = Mon; 3 = Tue; 4 = Wed; 5 = Thu; 6 = Fri; 7 = Sat. * With this in mind, let's create two copies of the drop-down list to select...

March 25, 202110
Received an upvote
The histogram based on two svg-images

Hi all, Based on the youtube channеl video of Smart Modeling Solutions I have created the dashboard part replica. Attached is the anime GIF file only. If anyone is interesting in how it to model let me...

March 25, 202110
Received an upvote
The histogram based on two svg-images

James, here is my model. It contains the minimal necessary explanations for matrices and their formulas. If you have questions on the model, I will try to answer. * Good luck

March 25, 202110
Load More