Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Michael,
Standard Qlik Pivot Table doesn't do this. You can solve it in two ways:
Jordy
Climber
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
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.
Hi Michael,
Standard Qlik Pivot Table doesn't do this. You can solve it in two ways:
Jordy
Climber
Thank you, it works