If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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 below expression to display top 10 ID's,
here i want to display top 10 % which means
i have total 60 ids out of 60 i want to display 6.
6 is top 10% values.
Please help me.
if you need more information please let me know.i need to resolve ASAP.
Thanks, In Advance
Create a variable:
vTop10 = Count(total distinct ID)*(10/100)
Then in exp:
View solution in original post
Thanks for your reply.
yes same way i did now i can able to see top 10 %.based on id
You are welcome