Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

PERCENTRANK

How would qlikiview duplicate  excels Function PErcentileRank =PERCENTRANK(B2:B8,13)

IDValuePercentILE Excel Rank
719
6150.5
514
413
312
29
18
3 Replies
jagannalla
Partner
Partner

=Fractile(Aggr(Value,Dim,Value), 0.13)

or you looking for rank function

rank( sum( Sales ))

Not applicable
Author

These do not give the result that I showed in my example above

Not applicable
Author

Im looking for ReverseFractile, Which is what PercentRank in Excel is