topic Re: Date Generation in QlikView

Date Generation

akpofureenughwu — Wed, 25 Nov 2020 16:16:04 GMT

Good day sir, I'm working on a excel file and I tried a code to generate day,month, year field from the existing date field but my output is blank or empty. I will need help from the community for this and possible help generate the quarter field too. Find attached files for clarity.

Re: Date Generation

sunny_talwar — Fri, 06 May 2016 15:47:55 GMT

Seems like your date might not be in DDMMYYYY format. Can you share how your datefield looks like in the raw data?

Re: Date Generation

akpofureenughwu — Fri, 06 May 2016 16:57:04 GMT

Hello sir, Let me try and send u the date field shot...

Please find the attached file.

Re: Date Generation

sunny_talwar — Fri, 06 May 2016 17:14:21 GMT

Try this:

LOAD *,

Month(Date) as Month,

Year(Date) as Year,

MonthName(Date) as MonthYear;

LOAD Date#(Date, 'DD/MM/YYYY') as Date,

....

Re: Date Generation

akpofureenughwu — Mon, 09 May 2016 08:38:52 GMT

Hello sunny, It worked. Thanks Man