Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bill_mtc
Partner - Creator
Partner - Creator

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
Gysbert_Wassenaar

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
Creator III
Creator III

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