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: 
rammuthiah
Creator III
Creator III

Exclude zero value in Bar Chart

The site is not allowing me upload the image. I want to exclude the zero value in Bar Chart. Can anyone help in this regards?

CY - Sum({<Year = {'$(=Max(Year))'}>} Sales)

LY - Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)

After applying

CY - if(Sum({<Year = {'$(=Max(Year))'}>} Sales)>0,Sum({<Year = {'$(=Max(Year))'}>} Sales))

LY - =if(Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)>0,Sum({<Year = {'$(=Max(Year)-1)'}>} Sales),'')

5 Replies
sibusiso90
Creator III
Creator III

Hi Ram

I hope this helps, I have a picture below.Show Zero.JPG

rammuthiah
Creator III
Creator III
Author

I tried this for the first time . After that I used the third and fourth expression. Can you please go through the second image. It was done , but the space between 2015 and 2014 is high. Can anyone help in this regard?

sunny_talwar

You seem to have two dimensions and two expressions, is that right?

rammuthiah
Creator III
Creator III
Author

! dimension with 2 Measures, Sunny

parthakk
Creator II
Creator II

HI Ram,

I dint get the use of if condition because your aggregated value will be greater than zero. So i doubt on working of if condition.

Can you share sample application?

Regards,

Partha K