topic Re: How to handle missing values in QlikSense 11 in QlikView

How to handle missing values in QlikSense 11

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to handle missing values in QlikSense 11

YoussefBelloum — Tue, 06 Feb 2018 09:26:25 GMT

Hi,

you can try this on the expression

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

Re: How to handle missing values in QlikSense 11

Anonymous — Tue, 06 Feb 2018 09:54:34 GMT

Thanks a lot Youssef, it worked fine.

Re: How to handle missing values in QlikSense 11

YoussefBelloum — Tue, 06 Feb 2018 10:03:27 GMT

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