topic Re: Hide Zero Columns in a Chart in QlikView

Hide Zero Columns in a Chart

Thu, 07 Nov 2013 22:01:48 GMT

If I have 4 Sums in a chart for Jan, Feb, Mar that simply sum up Sale by region. Example:

Jan Feb Mar

NE 1 2 0

SE 2 3 0

SW 1 4 0

Total 4 9 0

And I want to completely hide Mar because it is all 0's. Is this possible?

Put another way, can I hide columns that are all zero?

Thanks much.

Re: Hide Zero Columns in a Chart

mbm — Thu, 07 Nov 2013 22:15:45 GMT

Richard,

Try this expression as a conditional show for your expression. You may need to change the dimension name, and the sum statement to the value that's actually in your expression.

if(Max(Aggr(Sum(Sales), Region)) = 0, 0, 1)

Re: Hide Zero Columns in a Chart

nicolett_yuri — Thu, 07 Nov 2013 22:16:50 GMT

Uncheck de option

supress zero value in presentation sheet

Re: Hide Zero Columns in a Chart

Thu, 07 Nov 2013 22:20:41 GMT

Perfect, thanks. Simple!