topic Re: Hide zero lines in cummulative pivot table in QlikView

Hide zero lines in cummulative pivot table

bartvanwetten — Thu, 27 Oct 2016 13:49:36 GMT

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

Re: Hide zero lines in cummulative pivot table

Frank_Hartmann — Thu, 27 Oct 2016 13:53:30 GMT

what about this option?

Re: Hide zero lines in cummulative pivot table

bartvanwetten — Thu, 27 Oct 2016 13:55:34 GMT

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

Re: Hide zero lines in cummulative pivot table

Frank_Hartmann — Thu, 27 Oct 2016 14:09:29 GMT

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

Re: Hide zero lines in cummulative pivot table

bartvanwetten — Thu, 27 Oct 2016 14:18:20 GMT

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

Re: Hide zero lines in cummulative pivot table

bartvanwetten — Thu, 27 Oct 2016 15:15:06 GMT

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