Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide Zero Columns in a Chart


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.

1 Solution

Accepted Solutions
mbm
Employee
Employee

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)

View solution in original post

3 Replies
mbm
Employee
Employee

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)

nicolett_yuri

Uncheck de option

supress zero value in presentation sheet

Not applicable
Author

Perfect, thanks.  Simple!