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.



      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.


      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