How do I show "zero bars" on a Bar chart?

[#1]

I have a bar chart with one calculated dimension:

I wrote this formula so I would only see data for the past 7 days including the current day (nulls are suppressed):

=if(ChangeOpenDate<=today() and (ChangeOpenDate>=today()-6), Date(ChangeOpenDate, 'MM/DD')&' '&Weekday(ChangeOpenDate), null())

and the following expression:

Count({$<[Change Success Rating]={'Failed','Activation Issue'}, [Change Environment Description]={'Production'}>} Distinct [Change ID])

When there is no data for one of the days being shown, I want that bar to still appear, but with a "0".. I tried a few things such as un-supressing nulls, "show zero bars" etc. but nothing has worked so far..

[vinieme12]

Start your scale with -1 !

[sunny_talwar]

Would you be able to share where you have tried this for us to play around with?

[beck_bakytbek]

Hi Julian,

i think you want to achieve to make visible bar-chart on the base of zero-values,

i think this topic can contribute to solve your issue:

Qlikview Nulls() on a Bar Chart by RFB 185 - YouTube

i hope that helps

beck

[antoniotiman]

Probably, "When there is no data for one of the days" doesn't exixsts ChangeOpenDate,

so You don't have bar.

[#6]

Here is a sample of one chart.. i dont have data past Jan. 2016 in this example so you'll have to modify the calculated dimension.

[anagharao]

Hi ,

Is this what you were after?

[tyagishaila]

Expression:

if(ChangeOpenDate,

Count({$<[Change Success Rating]={'Failed','Activation Issue'}, [Change Environment Description]={'Production'}>} Distinct [Change ID]) ,0)

and go to Presentation Tab , click on Zero on Bars