Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Products that makes 80% of sales.

I need to do a pareto, the pareto part is easy using rowno() and sorting by sales, but I have a problem now and I haven't been able to find an answer, I need to order my Straight Table by Product, but need the pareto column to have the right number as if it would be ordered by sales.

I want to do this, the problem is that I don't know how to calculate the pareto without ordering by sales.

ProductSalesPareto
A$30,00085%
B$10,000100%
C$80,00040%
D$60,00070%
E$20,00095%
1 Reply
sunny_talwar

What is the expression that you are using right now?