Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Community,
I am facing an issue to hide zero or null() values on the combo chart.
The setup is as follows:
- I have 1 dimension - Week
- I have 15 master measures:
- 8 of them are bars that represent a weekly difference in the amount. I used this formula:
if(RangeSum([Open Amount AR] - Above([Open Amount AR]))<>0,RangeSum([Open Amount AR] - Above([Open Amount AR])))
- 7 of them are lines that represent the open amount : if(sum({<[Dependence category]={'AR'}>} Amount)<>0,sum({<[Dependence category]={'AR'}>} Amount))
I unchecked Show Zero values for dimension and also in data handling
... but still when filtering it shows zero/null() values for the measures which result is 0.
Is anybody seeing what is the issue here?
Thanks in advance!
I'm not seeing an issue - each of your dimension values (weeks) has at least one value, so none are hidden. As far as I know, hiding zero/null doesn't apply to measures.
Is there any way I can hide the measure if its value is null() or 0?
The issue here is that the combo chart allows only 1 dimension, so instead of having two dimensions (Week and Category), I had to create a measure for each Category (see them on the legend).
Maybe my whole approach is wrong, so if you have any ideas - welcome!
I'm not aware of any way to conditionally hide measures in the native Combo Chart. Maybe you could get cute with some if() statements, possibly mixed with aggr(), but this isn't a property you can set that I know of.
Some third-party extensions, such as Vizlib Combo Chart, may offer an option to conditionally enable/disable measures, if that helps any.
try like
if(sum(sales)=0,null(),sum(Sales))