3 Replies Latest reply: Jan 28, 2016 7:00 AM by Disha Ahuja RSS

    Extracting data in Qlik sense for different maximum values

    Disha Ahuja

      Hi All,

       

      I have a following kind of data.

       

      NameIdDate1Date2Count
      A0@@@@10
      A1@@@@11
      B0@@@@12
      B1@@@@12
      B2@@@@10
      B3@@@@9
      C0@@@@15
      C1@@@@15
      C2@@@@15
      D0@@@@18
      D1@@@@21
      E0@@@@20
      E1@@@@10
      E2@@@@18
      E3@@@@13
      E4@@@@13

       

      Now, I first want count for each Name corresponding to its respective maximum id.

       

      The result should be something like the following.

       

      NameIdDate1Date2Count
      A1@@@@11
      B3@@@@9
      C2@@@@15
      D1@@@@21
      E4@@@@13

       

      Now out of this intermediate result, I want to find top 3 name on the basis of count.

       

      The result should be:

      D: 21

      C: 15

      E: 13

       

      I have to show this count and name in the KPI visualization.

       

      Is there a way this can be done in Qliksense?

      May be we can some how extract the intermediate table in Load Script via some expressions and then the final result can be easily calculated in visualization by means of functions (firstsortedvalue(), aggr(). This part i am aware of!! )

       

      Or some other way, we can achieve this?

       

      Please help. In a crisis currently.

       

      Regards,

      Disha Ahuja