Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

How to limit the displayed data up to 80% cumulative sales?

One of the client's requirements is the TOP SKUs with 80% cumulative sales distribution. From the list, the SALES amount must be SORT DESCENDING. Then start accumulate the sales distribution. So, after full accumulation, I want to remove the SKUs that are greater than 80 percent. How could I do that? Is it possible? Please see image below for your reference.

80percentsales.PNG

Regards,

Bill

2 Replies
MVP & Luminary
MVP & Luminary

Re: How to limit the displayed data up to 80% cumulative sales?

Use a straight table and set the limit on the Dimension Limits tab to filter the rows based on the values of the first chart expression.


talk is cheap, supply exceeds demand
jafari_ervin
Contributor III

Re: How to limit the displayed data up to 80% cumulative sales?

You can use straight table and dimension limit >" show only values that accumulate" to option.