topic Re: Create date From Three Numbers in QlikView

Create date From Three Numbers

rebelfox — Thu, 06 Aug 2015 12:13:19 GMT

I loading three numbers from numeric fields which represent YYYY, MM and DD.

What is a simple way of setting these three fields as a single date value in the Load statement?

sasiparupudi1 — Thu, 06 Aug 2015 12:14:45 GMT

makedate(YYYY,MM,DD)

Kushal_Chawda — Thu, 06 Aug 2015 12:17:11 GMT

Try

=date(date#(YYYY&MM&DD,'YYYYMMDD'),'DD-MM-YYYY')

Thu, 06 Aug 2015 12:22:39 GMT

Hi Roy,

Below can help to you

Temp:

LOAD * INLINE [

YYYY, MM, DD

2010, 09, 08

2011, 03, 07

];

Final:

LOAD MakeDate(YYYY,MM,DD) as Date Resident Temp;

Regards,

Mahesh

rebelfox — Thu, 06 Aug 2015 12:25:43 GMT

Thanks, that's very easy.

sasiparupudi1 — Thu, 06 Aug 2015 12:36:22 GMT

Hi Roy,

Great!

Please close this thread if you got your answer so that it will be helpful for others

Thanks

Sasi