topic Re: Issue with MakeDate in QlikView

Issue with MakeDate

dafnis14 — Mon, 16 Apr 2018 13:10:24 GMT

Hi,

I'm trying to create a date with MakeDate function in a LOAD, but somehow I get null values.

The data:

TargetName	Target_Dim	Month	Target	Target_MonthStartDate
XXX	10	1	10
XXX	10	2	10
XXX	10	3	10
XXX	10	4	10
XXX	12	1	10
XXX	12	2	10
XXX	12	3	10
XXX	12	4	10
XXX	14	1	10
XXX	14	2	10
XXX	14	3	10

The script:

Temp_Targets:

LOAD Target_Dim,

TargetName,

Month,

Target,

MakeDate(2018,Month,1) as Target_MonthStartDate

FROM

$(vPathTempData)Temp_Targets.qvd

(qvd);

What is the reason?

Thanks!

Message was edited by: Dafnis X attached QVW

Re: Issue with MakeDate

sasiparupudi1 — Mon, 16 Apr 2018 13:23:31 GMT

It works normally for me...Make sure that you are selecting the field from the temp table

T1:

Load * Inline

[

TargetName,Target_Dim,Month,Target, XX

XXX,10,1,10,

XXX,10,2,10,

XXX,10,3,10,

XXX,10,4,10,

XXX,12,1,10,

XXX,12,2,10,

XXX,12,3,10,

XXX,12,4,10,

XXX,14,1,10,

XXX,14,2,10,

XXX,14,3,10

];

Temp_Targets:

NoConcatenate LOAD Target_Dim,

TargetName,

Month,

Target,

MakeDate(2018,Month,1) as Target_MonthStartDate

Resident T1;

Drop table T1;

Re: Issue with MakeDate

sunny_talwar — Mon, 16 Apr 2018 13:27:24 GMT

Is your Month field like Jan, Feb, Mar by any chance?

Re: Issue with MakeDate

marcus_sommer — Mon, 16 Apr 2018 13:28:10 GMT

I think the only reason is that Month isn't numeric - you could check it with num() or isnum() and maybe adjusting it with num#() or trim() or keepchar() and similar.

- Marcus

Re: Issue with MakeDate

dafnis14 — Mon, 16 Apr 2018 13:35:26 GMT

Hi,

I attached a QVW...it's a number

Re: Issue with MakeDate

dafnis14 — Mon, 16 Apr 2018 13:36:03 GMT

Thanks, but it still doesn't work.

I attached the QVW with the data

Re: Issue with MakeDate

sunny_talwar — Mon, 16 Apr 2018 13:37:43 GMT

Can you try this

MakeDate(2018,MonthNum*1,1) as Target_MonthStartDate

or this

MakeDate(2018,Num#(MonthNum),1) as Target_MonthStartDate

Re: Issue with MakeDate

dafnis14 — Mon, 16 Apr 2018 13:39:07 GMT

You were right!

num# solved it. Thanks!