How to show the missing measure values as zeros?

[qlikviewwizard]

Hi All,

I want to show Qty values zero for missed values.How to show the missing measure values as zeros?

Present output:

Required output:

Script:

Table:
Load *,
Month(date(Date)) as Month,
Ceil(Month(date(Date))/3) as Quarter,
Year(date(Date)) as Year;
Load * Inline [
Date,Qty
1-01-2015,1
2-02-2015,2
3-03-2015,2
4-04-2015,
5-05-2015,
1-06-2015,5
2-12-2014,6
3-11-2014,7
4-10-2014,8
5-09-2014,9
];

[qlikviewwizard]

Hi All,

Please help me.

[mdmukramali · Accepted solution]

Dear ,

Kindly find the attached file.

i hope it will help you.

Thanks,

Mukram.

[antoniotiman]

Hi,

You add in script

NullAsValue Qty;

Set NullValue = 0;

and in LOAD

Load Date,Num(Qty) as Qty,.......

Regards,

Antonio

[qlikviewwizard]

Hi AntonioTiman,

Could you give me whole script. I am confusing.

[antoniotiman]

NULLASVALUE Qty;
Set NullValue = 0;

Table:
Load Date,Num(Qty) as Qty,
Month(date(Date)) as Month,
Ceil(Month(date(Date))/3) as Quarter,
Year(date(Date)) as Year;
Load * Inline [
Date,Qty
1-01-2015,1