7 Replies Latest reply: Jan 9, 2017 7:55 AM by ANKITA BEHERA RSS

    How to calculate rank on nested aggregation in Qliksense expression.

    ANKITA BEHERA

      Hi,

      I have 5 levels of data and granularity is from 5th level. I need to calculate rank of average value based on city.

      so i have written the below calculation:

      Rank(aggr(Avg( Aggr(Avg(Aggr(Avg((Aggr(avg(Score),distinct[Level 4]))),distinct[Level 3])),

      distinct[Level 2])),[Level 1]),City)

      But when I am trying to create a Table with dimension city,level1,leve2,level3,level4,level5 and Rank, its returning null value.

      Please help as I am new to Qliksense.

      My requirement is my cities should be ranked based on the total average of all levels value.

       

      Thanks!!