6 Replies Latest reply: Feb 21, 2018 8:34 AM by Jahanzeb Hashmi RSS

    How to get Totals while using aggr in Qliksense

    siddharth soam

      Hi ,

       

      I am grouping my expression according to a column using 'aggr' in the expression editor. I am not able to get any value in Totals column.

       

      For example,

       

      I want to display aggr(sum(aggr(sum(revenue),city)),country), how can I get the corresponding expression to flash in the Totals row?

       

        

      CountryCityRevenue($ mn)
      IndiaDelhi12
      IndiaGurgaon4
      IndiaNoida11
      IndiaPune17
      IndiaHyderabad5
      IndiaBanglore7
      USANew York13
      USALA3
      USADetroit2
      USAWashington15

       

       

      I want my final aggregation with respect to countries