Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Master II
Master II

Hi All,

Please help me.

Highlighted
Specialist III
Specialist III

Dear ,

Kindly find the attached file.

i hope it will help you.

Thanks,

Mukram.

View solution in original post

Highlighted
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

Highlighted
Master II
Master II

Hi AntonioTiman,

Could you give me whole script. I am confusing.

Highlighted
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