Discussion Board for collaboration related to QlikView App Development.
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 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?
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.