topic Re: How to remove Null Bar from Bar chart in QlikView

How to remove Null Bar from Bar chart

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

Hi Experts,

Can anyone please help me on this.

In the below bar chart I need to remove the [Null] bar from the Partner Dimension.

I have to remove only from this chart in UI not from the complete app in the backend.

Please help me on this.

Thanks in Advance.

Anonymous — Thu, 18 Jan 2018 17:10:21 GMT

Use as a dimension

=if([Partner Dimension] = '[Null]', null(), [Partner Dimension])

and then uncheck the box "Show null values" on the dimension

devarasu07 — Thu, 18 Jan 2018 17:20:35 GMT

Hi,

try below methods,

Method 1) Try to suppress null value from your dimension field "Partner"

Method 2) try to exclude null using set analysis expression

let say you have measure as Sales then

sum( {$<Sales={">0"}>}Sales)

sum( {$<Partner={"=Len(trim(Partner))>0"}>}Sales)

Thanks,

Deva