topic Re: Unable to hide zero or null() values on combo chart in App Development

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

Lazar1 — Thu, 10 Aug 2023 09:51:45 GMT

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!

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

Or — Thu, 10 Aug 2023 09:59:59 GMT

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.

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

Lazar1 — Thu, 10 Aug 2023 10:04:51 GMT

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!

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

Or — Thu, 10 Aug 2023 13:30:16 GMT

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.

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

anat — Thu, 04 Jan 2024 12:29:57 GMT

try like

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