No Totalsum in Pivot

[MichaelFL]

Hello,

I often have the problem, that no TOTALS are formed in some calculation in pivot tables.

Example below with  Value SK, no Total sum in the top. I don´t know why. In a standard table i can choose additional the  sum function but in pivot I always have the problem.  

is it due to zero vales or empty values?

thanks for helping in advance!

[JordyWegman]

Hi Michael,

Could you add the QVF maybe? Maybe it's because there is a invalid character in the data set. But without data it's hard to say.

Jordy
Climber

[MichaelFL]

Hi Jordy, many thanks for your answer and sorry for my late reply.

Unfortunately, I am not able to provide the QVF.  I addition to what I have mentioned above I can say that the missing total could be due to missing zero values. Is it possible to convert "-" values to "0" values?

In excel I can prevent this issue with iserror function. With a simple if clause I have tried it already in qlik sense.

[JordyWegman · Accepted solution]

Hi Michael,

Standard Qlik Pivot Table doesn't do this. You can solve it in two ways:

1. Create the combinations in your data model so the result adds up to 0. So your dimensions should be linked.
2. Use the Vizlib Pivot Table. There you can replace the - with 0.

Jordy
Climber

[MichaelFL]

Thank you, it works