6 Replies Latest reply: Nov 20, 2013 4:31 PM by Shuyu Wang RSS

    Missing Partial Sum in pivot table

      Hi

      I am trying to calculate the forecast deviation, but qlikview didn't show sum correctly. Below I have the sample data file and expected pivot table in Qlikview. The function I used to calculate the difference is "above". Is there a better function which can achieve the same? Thanks!

       

      ---------------------------------------------------------------------------------------------------------------------------------------------------

      Data:

      Product Name   Type of Data            Qty

      Product A                 Forecast                3

      Product A                 Actual                    4

      Product B                 Forecast                5

      Product B                 Actual                    6

       

      Qlikview pivot table table:

      Product

      Type of Data

      Difference (sum(total(<[Product Name],[Type of Data]> Qty)-above(sum(total(<[Product Name],[Type of Data]> Qty))

      A

      Forecast

      -

      Actual

      1

      B

      Forecast

      -

      Actual

      1

       

      SUM

      ???