Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
chriscools
Creator II
Creator II

cumulative sales, % and rank to perform 80/20 analysis

Hello,

i have a pivot table in which i show sales per article sorted by value from high to low.

Now i take this list into excel and add the following: (see the attachment)

     -cumulative value

     -cumulative value in % of the total

     -i give a rang number according to the value sold (1= most, 2= second most,...)

     -the % of this rang number of the total number of articles, to have a 80/20  idea

i hope there might be a way to do this directly into qlikview so i don't have to this work every time in excel?

grtz,

chris

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

All these things could be done in qv directly - look at the attachment for cumulative your values. If you sorted your pivot it could reach to use rowno() for ranking but there are also rank-functions available - press F1 and look for rank.

- Marcus