# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor 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
Honored Contributor II

## Re: Top 10 % in qlik sense

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
Honored Contributor II

## Re: Top 10 % in qlik sense

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
Contributor II

Hi Jyothis,