Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master II

How to show the missing measure values as zeros?

Hi All,

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

Present output:

Capture1.JPG

Required output:

Capture2.JPG

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

];

1 Solution

Accepted Solutions
mdmukramali
Specialist III
Specialist III

Dear ,

Kindly find the attached file.

i hope it will help you.

Thanks,

Mukram.

View solution in original post

5 Replies
qlikviewwizard
Master II
Master II
Author

Hi All,

Please help me.

mdmukramali
Specialist III
Specialist III

Dear ,

Kindly find the attached file.

i hope it will help you.

Thanks,

Mukram.

antoniotiman
Master III
Master III

Hi,

You add in script

NullAsValue Qty;

Set NullValue = 0;

and in LOAD

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

Regards,

Antonio

qlikviewwizard
Master II
Master II
Author

Hi AntonioTiman,

Could you give me whole script. I am confusing.

antoniotiman
Master III
Master III


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