Can anyone help me out on this challenge?
in attached QlikView document there is a pivot finincial cumulative balance. The numbers are presented correctly but I want to hide the lines where every month (and thus total) is a zero.
I've tried the regular checkboxes and expressions but I can't get it to work.
Any help appreciated!
thanks for your comment but that's not what I need.
"I've tried the regular checkboxes and expressions but I can't get it to work."
What I need is the lines with in the months a 0 disappear. So if the every month in one line is 0 than the line should disappear.
As far as I understood you your requirement is as follow:
the red area should disapear? then use the above mentioned solution
If this is not your requirement then give more information about the expected output
you are totally right. Works like charm! But what I see is that
If I open the application in Qlik 12, it shows a different version of the pivot.
Whe I open the applicatoin in Qlik 11.2 I have what I want :s
So back to 11 I guess.