Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Error in Pivot Table totals - only "-" show

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!

1 Reply
MVP
MVP

Re: Error in Pivot Table totals - only "-" show

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