26 Replies Latest reply: Mar 7, 2018 2:23 AM by Prashant Sancheti RSS

    Export to excel total not matching with Qlik Straight table total

    Prashant Sancheti

      Hi team

       

      I am having Straight Table as Chart

       

      I am having a following as Dimention :  Customer

      measure:

       

      if (vPeriod = 'YTD',

       

      if (sum([Cost Price]) <> 0 ,

       

      if (Sum([SP]) <> 0, num(sum([YTDSales]) - Sum([YTDFxSales]), '#,##0'), num(sum([YTDSales]), '#,##0')), 0),

       

      )



      Total in the Staright table is showing correct result.

       

      but when i am trying to export this data and try to compare the total in excel and Total in Table is not matching .

       

      What could b the reason .

       

      Please provide your valuable comment as early as possible.