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, expressions but I can't get it to work.

Any help appreciated!

Regards,

Bart

[sunny_talwar · Accepted solution]

Like this?

[bartvanwetten]

Sunny,

do you ever sleep?

No it's not the way because my numbers change. It should just 'remove' the lines in wich every month is a zero (or null?) amount.

Thx mate!

[bartvanwetten]

Hi Sunny,

the solution you offered was right! The result differs between qv11 and qv12. Check it out.

So back to 11 I guess :s

Bart

[sunny_talwar]

So there is an issue between QV11 and QV12? Which one is giving the right numbers?

[bartvanwetten]

11!