Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
Showing results for 
Search instead for 
Did you mean: 

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...


Arjun TK

Labels (1)
1 Reply

You can do in your measure A something like this:

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