5 Replies Latest reply: Mar 25, 2018 10:01 PM by Davis Vickers RSS

    Pivot Table Total of a FABS(Sum...

    Matthew Morge

      Hi Guys,

       

      I have been working on a forecast accuracy report in Qlik Sense. I have a pivot table displaying daily sales qty's & forecast qty's, volume error and percentage error measures. The issue that I am having is that when applying the total function to the pivot table, the error volume measure is not picking up the values from the FAB calc. It is netting the negatives off of the positive values and giving a much lower result that expected.

       

      The expression I have is as follows:

       

      =FABS(SUM({$<[CATALOG_NO],[TIMEFENCE_FLAG]={Y},[VALID_SET_FLAG]={Y}>}[FORECAST_LEV0])-

      SUM({$<[CATALOG_NO],[TIMEFENCE_FLAG]={Y},[VALID_SET_FLAG]={Y}>}DESIRED_QTY))

       

      What I have read indicates that I need to incorporate the AGGR function but being new to QS I am struggling on how to do this correctly.

       

      Help would be gratefully received.

       

      Thanks,

       

      Matt