1 Reply Latest reply: Jun 24, 2016 8:03 AM by Sunny Talwar RSS

    Error in Pivot Table totals - only "-" show

    Trinh Le

      Hello everyone!

       

      I meet a strange error with Qlik Sense Pivot table: it's unable to calculate the total values by dimension:

      ex_.jpg

      (I edited out some details due to confidential problem)

       

      I don't use any custom calculation or Aggregation for the measures.

       

      I also tried to use formula to set the measures values = 0 if null / blank, but then the total also = 0.

       

      Data structure:

      ex2.PNG

      The 3 dimensions DIM1 DIM2 DIM3 has a hierarchy relationship as shown in the first pic.

       

      Could someone please help me fixing this?

       

      Thanks a lot in advance!