Exclude Zero bars

[New-Qlik]

HI ,

I have a requirement to exclude zero bar form a bar chart.

I have two dim and one exprsssion bar chart.

For dim who has no entry wrt to count are also coming in bar chart  just name on axis.

how can I exclude this.

I have tried all supress zero, null etc nothing working

[Anil_Babu_Samineni]

Can you please show the image, Please do supress Dimension level and Presentation respect

[kamal_sanguri]

The issue may be because of two dimensions, even if there is no Expression value for one dim other dim may have.

Pls check the attached doc. where you will see that despite the fact that there is no value for Expression, we have place holder for bar( blank space) in bar chart.

[New-Qlik]

!Thanks Kumar,

but I want both dim in x axis and legend should be of expression .

Please see attached your application with changes . in this for 2001 I am getting zero bars for march n april month .

I want to exclude that

[qlikview979]

Hi,

it will give  Zero for 2001 ,March,April no data  in your source.

[New-Qlik]

thanks rite so I don't want that in axis , just jan feb should come .for 2001

how to restrict that

[Anil_Babu_Samineni]

There is no default option to deserve this issue? Hope mrkachhiaimp‌ offer you work around. Let's wait for his response

[New-Qlik]

okay. @manish kindly guide

[MK_QSL · Accepted solution]

Like this?

Please note that there is no direct approach to handle in QlikView Bar Chart while using multiple dimension.

Thanks to rubenmarin‌ for suggesting this long time ago.

[New-Qlik]

Thanks Manish,I am not able to see the query you have posted sometime back inorder to get this result .

Can u please post again and if u can explain little bit .

Thanks in advance