Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
What is the expression you are using? Can you try this:
Sum(Aggr(ExpressionPlaceHolder, DIM1, DIM2, DIM3))
Replace your original Expression with the ExpressionPlaceHolder above