How to handle missing values in QlikSense 11

[Anonymous]

Hi,

I am using QlikSense 11. And I am facing the below issue.

I have the fields as DATE, Sales, Region, Owner. I creating a bar chart with dimension as Month of Date, and measure as Sales. It is showing data for all the months. The screenshot as follows.

Now when I am putting filter on it, for example owner = 'ABC', then for that selection data is only present only for three months. So the chart is showing bar for only three months. The values for other months are not present. Screenshot follows.

What I need to show all the months in dimension, even after filtering. May be a zero value for the missing months.

Please help how can I achieve that.

[YoussefBelloum]

Hi,

you can try this on the expression

Sum( Sales ) + 0 * Sum( {1} Sales )

[Anonymous]

Thanks a lot Youssef, it worked fine.

[YoussefBelloum]

you're welcome, you can close the thread by marking correct answer as correct.