Discussion board where members can get started with Qlik Sense.
i have a requirement to display top 10 % and Bottom 10% based on KM/lit.
i have a fields ID and KM/Lit.
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
Thanks in advance.
i suggest you to take a look at http://www.qlikfix.com/2010/10/08/decile-analysis/
it might help you.
I had tried but not getting expected output.
You should create Cumulative percentage first, from there consider the percentages.
Use the below type of expression for percentage considerations and use these expressions in Min, Max Range limits of Gauge chart.