Displaying top 10% and bottom 10 %in chart

[vinod2086]

Hi All,

i have a requirement to display top 10 % and Bottom 10% based on KM/lit.

i have a fields ID and KM/Lit.

KM/Lit=(sum(Diff_distance_drive)/sum(Diff_total_fuel_consumption)

=Aggr(if(rank(sum(Diff_distance_drive)/sum(Diff_total_fuel_consumption))<=,VIN,NULL()),VIN)

i have used above expression and able to display top 10 values but i want to display top 10%

e.g: i have total 60 id are present. here i need to calculate 60*(10/100)=6 6 is top 10% values.

Please help me

ID	KM/Lit
121	4.11
123	4.72
124	3.30
125	3.06
126	3.08
127	3.75
128	3.88
129	3.91
130	4.29
1311	3.42
132	4.10
133	2.83
134	3.91
135	3.91
136	3.64

Thanks in advance.

[agigliotti]

i suggest you to take a look at http://www.qlikfix.com/2010/10/08/decile-analysis/

it might help you.

[vinod2086]

Hi Andrea,

I had tried but not getting expected output.

[BalaBhaskar_Qlik]

You should create Cumulative percentage first, from there consider the percentages.

https://community.qlik.com/thread/262873

https://community.qlik.com/thread/128533

Use the below type of expression for percentage considerations and use these expressions in Min, Max Range limits of Gauge chart.

Sum({<Week={'>=$(=Max(Week)-4) <=$(=Max(Week))'}>}Data)