topic Re: Hide expression in pivot table when all zero values in QlikView

Hide expression in pivot table when all zero values

godfreydaniels — Wed, 30 Nov 2016 14:22:05 GMT

Hi,

I have a pivot table with months across the top and two expressions: one that is monthly, and one that belongs only to months in which a quarter ends. The users very much want to hide the quarterly measure except for those months for which it applies. So instead of:

they want to see:

I have tried using 'Suppress Zero Values,' but that seems to suppress the dimension, not the expression. Is there any way to achieve what is shown?

Thanks

Re: Hide expression in pivot table when all zero values

sunny_talwar — Wed, 30 Nov 2016 14:25:42 GMT

This can be done using Pick(Match()) function with an island table. What you need is to have just one expression so that 'Suppress Zero Values' can take its effect

Re: Hide expression in pivot table when all zero values

godfreydaniels — Wed, 30 Nov 2016 14:54:00 GMT

Thank you Sunny; could you please elaborate on this?

Re: Hide expression in pivot table when all zero values

sunny_talwar — Wed, 30 Nov 2016 14:59:37 GMT

See if this link helps:

How to suppress 0 in expression

Re: Hide expression in pivot table when all zero values

godfreydaniels — Wed, 30 Nov 2016 16:09:41 GMT

Thanks--that is a clever trick. It seems to break if a second expression is added. Can it be made to work alongside other expressions that are visible for every month? It is to go in an ad-hoc reporting table.

Thanks

Re: Hide expression in pivot table when all zero values

sunny_talwar — Wed, 30 Nov 2016 16:15:42 GMT

You will have to program all your expressions within a single expression using pick(Dim.... As soon as your add two expressions, things might not work.