PERCENTRANK

[#1]

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

ID	Value	PercentILE Excel Rank
7	19
6	15	0.5
5	14
4	13
3	12
2	9
1	8

[jagannalla]

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

or you looking for rank function

rank( sum( Sales ))

[#3]

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

[#4]

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