Unable to hide zero or null() values on combo chart

[Lazar1]

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!

[Or]

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.

[Lazar1]

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! 

[Or]

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.

[anat]

try like

if(sum(sales)=0,null(),sum(Sales))