Bar chart - need to show all dimensions

[Anonymous]

Hi,

I have a bar chart that looks like this.

I also have dimensions "6 months, 9 months and 12 months" but I don't have values for these at this time.

How do I get these to show on the vertical axis with no values?  As time progresses, there will be values.

Thanks

[swuehl]

If your dimensional table shows these values, but your fact table doesn't have records with a relation to these, maybe just try disabling 'suppress zero values' on presentation tab of chart properties.

[el_aprendiz111]

Hi,

[Anonymous]

OK, when unchecked "suppress zero values", it gave me this chart.  I expect to zero for 6 months

and 12 months.   See my QV table.

It appears the 2887 is being copied from 3 months.  Is there another setting that needs to be configured?

Actually the "3 months" has the wrong value.  It should be 1668.

[swuehl]

Have you maybe (unintentionally ?) enabled 'full accumulation' on expression tab?

[Anonymous]

You saved my day!!  Yes, I was playing around with various settings earlier trying to get this to work.  It's working now.

Thank you all.

BTW fer fer, I love your animations.

[Clever_Anjos]

el_aprendiz111‌ which tool you have used to generate this gif?

[Anonymous]

Hi fer fer,

What tool do you use to generate this animation?

[jitenderkalouni]

How can i achieve this in Qlik Sense ?