3 Replies Latest reply: Jul 27, 2018 3:17 AM by Jyothish KC RSS

    Top 10 % in qlik sense

    V Kumar

      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.

      Please help me.

       

      if you need more information please let me know.i need to resolve ASAP.

       

      Thanks, In Advance