How to Hide Zero value Bars

[New-Qlik]

hello everyone

I have a bar chart with three dim and one expression

for dim1 there are two value in dim2
example

Dim1   Dim2  Sales
a         open  100
a        closed  200
b        open  300
c        open  220
c        closed  100

now in bar graph on x axis i am getting two bars wrt to 'a' ie open and closed
but for 'b' also two bars comes one for open and for closed it shows zero bar

I want to restrict this zero bar.. it should show only OPEN for B

I have tries all features
suppress null
zero bars etc

kindly advice what needs to be done

Thanks

[qlikview979]

May be this

Can you please share the sample app

[sanjay006]

If you want to show Zero value on Chart :

Data:

NoConcatenate Load

district,

RangeMax(0.00000001, count) as count

resident Data_Raw;

Assuming the Data_Raw table contains your original raw data.

And use the num(Sum(count), '##0') as Measure in your Pie-Chart.

It produces the results you need (district FFFF contains 0 counts, but still represented on the chart):

And if you don't want zero values

Properties --> Presentation Tab --> Suppress Zero Values (Check that box)

[JianangZhao]

For Web Qlik Sense, we can do by "Add-ons"--> "Data Handling" -->  "Include Zero values" to hide zero values bars.