Show zero on bar chart for Dimension that has no expression value

[qlikwiz123]

I have Dimension with A, B, C, D values in it.

I am doing a Sum(Amount) in the expression of bar chart. Since 'A' has no Amount, it is not showing up in the bar chart. I want to show 'A' as a bar and have 0 against it. I removed Supress When value is null and enabled Zero on Bars in Presentation tab. I see the dimension now but with no value against it.

I even tweaked my expression as below but no use

if(Sum({$<[Dimension]={'A'}>}Amount)=0, NULL(),

Sum(Amount))

[Or · Accepted solution]

A bar of 0 would look exactly the same as no bar or a bar of null - there would be no bar as the length of it would be 0.

You could try using Alt(YourFormulaHere,0) to force a zero when the formula returns null, but there still won't be any bar...

[qlikwiz123]

This is exactly what I want. Thank you so much 🙂