topic How to show the missing measure values as zeros? in QlikView

How to show the missing measure values as zeros?

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

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
];

Re: How to show the missing measure values as zeros?

qlikviewwizard — Sun, 14 Jun 2015 08:44:59 GMT

Hi All,

Please help me.

Re: How to show the missing measure values as zeros?

mdmukramali — Sun, 14 Jun 2015 08:53:40 GMT

Dear ,

Kindly find the attached file.

i hope it will help you.

Thanks,

Mukram.

Re: How to show the missing measure values as zeros?

antoniotiman — Sun, 14 Jun 2015 08:54:19 GMT

Hi,

You add in script

NullAsValue Qty;

Set NullValue = 0;

and in LOAD

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

Regards,

Antonio

Re: How to show the missing measure values as zeros?

qlikviewwizard — Sun, 14 Jun 2015 09:48:58 GMT

Hi AntonioTiman,

Could you give me whole script. I am confusing.

Re: How to show the missing measure values as zeros?

antoniotiman — Sun, 14 Jun 2015 09:56:09 GMT

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