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

[kamal_sanguri]

To restrict data for only particular year. Use set analysis

Sum({<Year={2001}>}Sales)

[New-Qlik]

no they want in bar only .

[New-Qlik]

HI Manish,

I Tried your solution though its working with two dim one expression chart.

But in my case dre are two problems.

1. After assigning 0 to status as m doing count(status) I ma getting three values in status ie open , closed, 0

2. how do I do this with three dim and two expressions.

kindly guide

[MK_QSL]

Hi Avneet,

Please follow below steps.

1) We request you to provide sample data or sample application to work

2) Provide as much as possible information rather than adding questions in the same post.

Kindly close this thread by selecting appropriate answer.

Raise a new question with proper information.

Regards,

MK