New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for
Did you mean:
Creator II

Top 10 % in qlik sense

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)

i have used below expression to display top 10 ID's,

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

here i want to display top 10 % which means

i have total 60 ids out of 60 i want to display 6.

eg: 60*(10/100)=6

6 is top 10% values.

1 Solution

Accepted Solutions
Master II

Hi Kumar,

Create a variable:

vTop10 = Count(total distinct ID)*(10/100)

Then in exp:

=Aggr(if(rank(sum(Diff_distance_drive)/sum(Diff_total_fuel_consumption))<= \$(vTop10),ID,NULL()),ID)

Br,

KC

Best Regards,
KC
3 Replies
Master II

Hi Kumar,

Create a variable:

vTop10 = Count(total distinct ID)*(10/100)

Then in exp:

=Aggr(if(rank(sum(Diff_distance_drive)/sum(Diff_total_fuel_consumption))<= \$(vTop10),ID,NULL()),ID)

Br,

KC

Best Regards,
KC
Creator II
Author

Hi Jyothis,

yes same way i did now i can able to see top 10 %.based on id

Master II

You are welcome

Best Regards,
KC
Tags
Community Browser