S A U | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Asked a question
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...

3 days ago2
Posted an answer
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...

4 days ago5
Posted an answer
Copy values of one item to another across all matrices

Hi Tahir. Thank you for sharing the a-script. It was informative. I have optimized a little bit a-script:

June 4, 20195
Posted an answer
Copy values of one item to another across all matrices

In the attached model there are 5 matrices in total. Manually filling their cells would not take a long time ... Another question: what is the data source for the 'Plan' Item for each of the three matrices...

June 2, 20195
Posted an answer
Copy values of one item to another across all matrices

Hi, for May 2019 manually fill in the cells of all matrices instead of the script: what exactly do you want to get in the model?

June 2, 20195
Posted an answer
Reference Formula

Well, then what is the specificity of the Oct..Mar range? For example, why are its values set to "space"?

May 3, 20195
Posted an answer
Reference Formula

Hi, * what value should be in the range Apr..Sep for the Forecast?

May 2, 20195
Received an upvote
Sublist Function: Unable to retrieve data wrt Year

Hi, Try this formula: Revenue = sum(sublist(LayoutofMonth::Month:Revenue; 1)) skip Better Worse

April 13, 201910
Posted an answer
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...

April 11, 20195
Posted an answer
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.

April 3, 20195
Asked a question
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...

April 3, 20192
Received an upvote
April 1, 201910
Posted an answer
Script to delete rows

This is the variant of the A-script with a preliminary request of the Items Group and Item for the Deletion. Provided all the Items of the Dept category are divided into groups, the A-script works correctly....

March 30, 20195
Posted an answer
Script to delete rows

Hi, Try the simplest A-script for the problem solve.

March 30, 20195
Posted an answer
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 22, 20195
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 22, 201910
Received an upvote
March 22, 201910
Posted an answer
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 19, 20195
Posted an answer
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 19, 20195
Asked a question
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 17, 20192
Load More