topic Re: Input Box N% will show the Cumulative sum of Rows in QlikView

Input Box N% will show the Cumulative sum of Rows

dmohanty — Mon, 18 Mar 2019 14:37:22 GMT

Hi Team,

Attached a sample QVW file, which shows Sales and Sales %.

I need to input the N% in the Input Box provided. If the Input Box value equals to the highest Sales %, then that particular Row should be displayed in the chart.

If I increase the N% in the Input Box, the chart would continue to show the one row in the chart until the second highest % is not summed up with the highest one (kind of Pareto Analysis).

This is just a sample data file. The Real App will be having a lot more Dimensions and Expressions. So if the User is trying to Sort any columns and selects any value, the Mathematics suppose to work correctly. 🙂

For example, In the Attached File,

if I enter any value less than 18% (highest) in the Input box - Zero Records.
if I enter 18%, the record with Sales and Sales% as 18% will show up - One Record
if I enter any value between 18-33, (18% + 16% [2nd highest] = 34%), still Sales and Sales% as 18% will show - One Record
if I enter any value between 34, (18% + 16% [2nd highest] = 34%), Sales% as 18% and 16% will show - Two Records
if I enter any value between 45, (18% + 16% + 12% [3rd highest] = 46%), Sales% as 18% and 16% will show - Two Records
if I enter any value between 46, (18% + 16% + 12% [3rd highest] = 46%), Sales% as 18%, 16%, 12% will show - Three Records.

Thank you.

Re: Input Box N% will show the Cumulative sum of Rows

dmohanty — Mon, 18 Mar 2019 18:37:16 GMT

Hi,

Any possible help here yet please?

Regards!

Re: Input Box N% will show the Cumulative sum of Rows

tresB — Tue, 19 Mar 2019 07:56:15 GMT

Ideally, dimension limits and 'Show only values that accumulate to:' setting (in your case, you could use variable in place of the percent indicator ) should have worked for this, I guess. However, somehow it's behavior unpredictable. This could be a bug. You may want to raise this with Qlik Support.

Re: Input Box N% will show the Cumulative sum of Rows

dmohanty — Tue, 19 Mar 2019 08:00:47 GMT

Hi @tresB,
You are right. These behaviors are unpredictable.

Can you please attach me a sample solution on this please?
I have been calculating the Cumulative Sales, but somehow not coming as expected. (keep on changing when we sort columns)

Also, I don't want to calculate a Cumulative Sales (like using RangeSum) in a LOAD SCRIPT, as the volume is is quite high and that will consume time and alter performance.
So was trying to don on the fly on the Chart level (original chart has some 50 Dimensions and Measures).

Re: Input Box N% will show the Cumulative sum of Rows

dmohanty — Tue, 19 Mar 2019 08:22:26 GMT

Hi @tresB,

How can I show the values like this (mentioned in Red in the rows) -