1 Reply Latest reply: Feb 19, 2018 4:46 AM by omar bensalem RSS

    Total disappears in export to excel in Qliksense

    onkar kulkarni

      Hello All,

       

      I have a table in Qliksense dashbaord with customer counts on different levels. I am showing total(customer_ID) in first row. When I right click on Export data, in excel total row is not available.

       

      Is this bug/ limitation in Qliksense ?

       

      Regards,

      Onkar Kulkarni

        • Re: Total disappears in export to excel in Qliksense
          omar bensalem

          do sthing as follow:

          do sthing as follow:

           

          create a new column in ur table as follow:

          =aggr(if(len(Above(OneOfYourDimensionsInTheTable))>0,'', Sum(TOTAL YourMeasure)),OneOfYourDimensionsInTheTable)

           

          in my case : if I wanted to export the current selections for example instead of the total : (per analogy, it will export the total the same way)

           

          =aggr(if(len(Above([Territory name]))>0,'', GetCurrentSelections(' | ')),[Territory name])

          Result:

          Capture.PNG