topic Re: Deleting null values from a bar chart in QlikView

Deleting null values from a bar chart

sdaniels0606 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a problem with a bar chart. When I try deleting the null values I dont need, the chart creates a new label named "-".

To delete the Null values I use "Alt(expresion,' ')" or "If(IsNull(Expresion),' ',Expression)".

-->

BTW, the values Im trying to erase are from a second expression without bars.

Re: Deleting null values from a bar chart

sunny_talwar — Wed, 18 Jan 2017 13:46:40 GMT

Once you use your calculated dimension, you need to check 'Suppress When Value Is Null' on the dimension tab of the chart properties to hide those null values

Re: Deleting null values from a bar chart

surendraj — Wed, 18 Jan 2017 13:58:25 GMT

Hi,

Here is the another way,with out using the supress null values,we can restrict it by using set analysis.

sum({<sales-={'0'}>}sales)

--surendra