stacked bar chart issue

[Anonymous]

show spaces when values are null in qlikview

pfa file

In the chart, Sales bar should show P1,P2,P3 even though P2 is null

john

[sunny_talwar · Accepted solution]

Something like this?

Expression: =If(Sum({$<Customer ={'A'}>}sales) = 0, 1, Sum({$<Customer ={'A'}>}sales))

[Anonymous]

Thnx Sunny, this is what I needed.