Hide zero lines in cummulative pivot table

[bartvanwetten]

Hi all!,

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!

Regards,

Bart

[Frank_Hartmann · Accepted solution]

what about this option?

[bartvanwetten]

Hi Frank,

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.

Bart

[Frank_Hartmann]

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

[bartvanwetten]

Hi Frank,

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.

Anyway thanks!!

Bart

[bartvanwetten]

Hi Frank,

Now I want a total of rows in the pivot on the first dimension but it shows the total indepent of my if statment in the expression.

Can help me out again for once?

Thanks,

Bart