Hide 0 values in combo chart

[Arjun_TK]

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

[goncalo_ricardo_pereira]

You can do in your measure A something like this:

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