EXCEL Like Function in Qlikview

[#1]

Can someone Help me replicate the Excel Function   PERCENTILE in Qlikview

     Excel Function =PERCENTILE(B2:B8,0.8)

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

[jagannalla · Accepted solution]

fractile( Sales, 0.75 )

[#3]

How about PercentileRank ?

[#4]

How about PercentileRank ?

[jagannalla]

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

or you looking for rank function

rank( sum( Sales ))

[#6]

This does not come up with PercentRank from Excel. If you look at the above table and values I am looking for the exact value that excel returns in the formulas.