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:


      (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:


      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!