Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
New-Qlik
Creator II
Creator II

How to Hide Zero value Bars

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

3 Replies
qlikview979
Specialist
Specialist

May be this

Untitled.png

Can you please share the sample app

sanjay006
Creator
Creator

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
Contributor II
Contributor II

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