Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can do in your measure A something like this:
if(isnull(sum(Sales)), null(), sum(Sales))