# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner

## Input Box N% will show the Cumulative sum of Rows

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,

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

Thank you.

4 Replies
Partner

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

Hi,

Any possible help here yet please?

Regards!

MVP

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

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.

Partner

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

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