Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Hide 0 values in combo chart

Hi Team,

I just want to know if there a way to hide the 0 values in the graph.
Here is the scenario behind it. We have two measures A and B where A has a filter for year "2015-2018 but whereas the measure B does not have any filter in Year i.e.(2012-2018) because of which I am getting the 0 values for Measure A in 2012,2013,2014 so is this achievable in Qlik? Please let me know...

Thanks

Arjun TK

Labels (1)
1 Reply
Highlighted

You can do in your measure A something like this:

if(isnull(sum(Sales)), null(), sum(Sales))