Qlikview % of Total Ranked

[mkudis]

I have my list of data (Branch, Item, Customer) ranked in a pivot table based on the field "ext_price_gross", which is working just fine.  What I'm looking to do is to then give me a percentile based on these rankings.  I'm figuring that I have to do something like:

1 - ((ranking value) / (max of total ranking)

If my Ranking Value that works is: Rank(sum(ext_price_gross),3,1)

then how do I get the max of the rankings?

If I have 100 things ranked, the 5th ranked thing should return 95% (1 - (5/100))

Thank you.

[Luis_Galvan]

If you are using version 12.80 or above in QlikView, I suggest to look at this new capability that came from this version

WRank - script function | QlikView Help

Downsize is that this capability is at the load script and not at the UI - Chart; however, it will easily resolve your challenge

[Nagaraju_KCS]

May be this

= 1 -
(Rank(Sum(ext_price_gross), 3, 1) 
/
Aggr(Count(TOTAL DISTINCT Branch, Item, Customer), TOTAL)