topic Re: How to Hide Zero value Bars in QlikView

How to Hide Zero value Bars

New-Qlik — Wed, 17 May 2017 05:32:25 GMT

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

Re: How to Hide Zero value Bars

qlikview979 — Wed, 17 May 2017 05:53:44 GMT

May be this

Can you please share the sample app

Re: How to Hide Zero value Bars

sanjay006 — Wed, 17 May 2017 06:18:21 GMT

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)

Re: How to Hide Zero value Bars

JianangZhao — Thu, 22 Aug 2019 00:42:31 GMT

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