S A U | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Posted an answer
How to place Labels inside of a Pie Chart

Here is chart's reaction to the empty: * * Here is chart's reaction to the null: * * Good luck.

November 17, 20205
Asked a question
How to place Labels inside of a Pie Chart

A while ago, I have read this question. If to answer briefly, have to say so: it can't be done with regular tools. However, I found a way to mimic a solution to the problem. * * Good luck.

November 17, 20202
Posted an answer
A Doughnut Chart. Demo of QM’s possibilities

Continuing the topic. This time it is example of indicator of the share of the cost element: * * Good luck.

November 17, 20205
Posted an answer
A-script. Remove all REMs from model formulas

Screenshot of the A-script: * * Good luck

October 28, 20205
Posted an answer
A-script. Remove all REMs from model formulas

Solution demo This two-matrix model is a simplified version of the real one. The script-button on the canvas serves as a simplifying tool for showing the results of the A-script. I cancel the A-script...

October 28, 20205
Asked a question
A-script. Remove all REMs from model formulas

Problem There are cases when you want to quickly delete all formulas's comments of a model. Below I show my solution in the form of an Action script. This A-script uses RegEx that matches both single-line...

October 28, 20202
Posted an answer
A Doughnut Chart. Demo of QM’s possibilities

Continuing the topic. This time it is same example of indicator with the dashed scale and needle in two versions that was in the previous post. The only difference is that the arrow of the left indicator...

October 17, 20205
Commented on a post

It will be easier to help you if you attach a QM file indicating both the actual data and the period for the forecast data.

October 16, 20202
Posted an answer
A Doughnut Chart. Demo of QM’s possibilities

Continuing the topic. This time it is another example of indicator (based on doughnut chart) with the dashed scale and needle in two versions: * * Good luck.

October 12, 20205
Posted an answer
Trailing 12 Month Financial – Income Statements

I continue the Mark's theme with a brief description of my method for the problem solving. My method is do not use the 'Trailing 12 Time Utility' matrix at all for data sampling purposes. Instead, a single...

September 28, 20205
Commented on a post

Mark, I'm glad you have appreciated my solution of the problem.

September 25, 20202
Commented on a post

Tom, thank you for your comment. I really appreciate it.

September 25, 20202
Posted an answer
Trailing 12 Month Financial – Income Statements

Hi Mark, I welcome your demonstration of TTM implementation in QM. Without any doubt, this is a mature implementation. Please continue to share your experience further. * Regards, SAU

September 24, 20205
Posted an answer
Average Line in a Chart

So far no one has answered the question. * I inform QM users. There is simple way to draw an average value line on the histogram. To do this, use the Combined (2D) chart type with two data series. Assign...

September 14, 20205
Posted an answer
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

August 31, 20205
Posted an answer
Pareto chart combined with ABC-analysis

This report includes a tabular part with an source data, Pareto diagram, calculated Pareto chart totals in the form of chart's legend, and tools for setting thresholds for accumulative percentages for...

August 29, 20205
Asked a question
Pareto chart combined with ABC-analysis

Hi All! * In order to support the QM community. * This time I will demonstrate a combination of Pareto chart and ABC analysis. Suppose we have income for a certain period for 10 product groups. We have...

August 29, 20202
Posted an answer
QM’s quasi-Problem: Value not found in list of acceptable values

Here's my answer. One way to resolve this situation may be a small modification of the Constrain InputDynamic List option: * * The user gets the opportunity to set a complete list of the original selection...

August 20, 20205
Posted an answer
A Doughnut Chart. Demo of QM’s possibilities

Continuing the topic. This time it is the example of 5-segments semi-ring indicator: * * * Good luck.

August 20, 20205
Asked a question
QM's quasi-Problem: Value not found in list of acceptable values

Hi all Challenge. Let's suppose we want to restrict the selection of options in the drop-down list by hiding the options that were previously selected. For example, if we are assigning employees to duty...

August 10, 20202
Load More