Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
madhubabum
Contributor

how to supress null values & zero's in Barchart

Hi, All

Here i am taking as dimension as "Sub_Division" and Expression as Sum(      ) ...

Here i want to show others values as "others" on X-Axis ....& i want to remove zero's on my X-Axis .....

How to Achieve this one ..?

Thanks  To All

Madhu

1.png

2 Replies
buzzy996
Honored Contributor II

Re: how to supress null values & zero's in Barchart

on ur expression tab :

=if(sum( urfieldname)>0.1,sum( uefieldname),null())

on ur dimesnion tab:

check the check box, suppress when value is null

Not applicable

Re: how to supress null values & zero's in Barchart

Dimension Tab,

suppress when value is null

Presentation tab:

suppress missing

suppress zero values.

in dimension limit

check show others for other values