topic Re: Date Scripting in QlikView

Date Scripting

akpofureenughwu — Mon, 14 Nov 2016 19:32:15 GMT

Greetings evening,

Please I need assistance in creating the day function on this date script.

load*,

'Q'&ceil(month(date#([Month],'MMM'))/3) as [Quarter],

Date(Date#(Month&'-'&Year, 'MMM-YYYY'), 'MMM-YYYY') as Date;

load

.....................................................

[Fiscal year/period - Fiscal year/period Level 01 (Key)],

[Fiscal year/period - Fiscal year/period Level 01 (Text)],

right([Fiscal year/period - Fiscal year/period Level 01 (Text)],4) as Year,

Capitalize( If(Index('SP1,SP2,SP3,SP4,Per,', left([Fiscal year/period - Fiscal year/period Level 01 (Text)],3)),'DEC', left([Fiscal year/period - Fiscal year/period Level 01 (Text)],3))) As [Month];

With the above script, I can only generate year, quarter, month, date

I need the day function.

Thank you for viewing this

Regards

Re: Date Scripting

its_anandrjs — Mon, 14 Nov 2016 20:15:36 GMT

Please provide some sample data to look over.

Regards

Anand

Re: Date Scripting

johnw — Tue, 15 Nov 2016 00:01:12 GMT

The day of the month? Maybe this?

day(date#(Month&Year,'MMMYYYY')) as [Day of Month]

Re: Date Scripting

MarcoWedel — Wed, 01 Mar 2017 19:25:21 GMT

maybe like this:

load *,

Day(Date) as Day;

load*,

'Q'&ceil(month(date#([Month],'MMM'))/3) as [Quarter],

Date(Date#(Month&'-'&Year, 'MMM-YYYY'), 'MMM-YYYY') as Date;

load

.....................................................

[Fiscal year/period - Fiscal year/period Level 01 (Key)],

[Fiscal year/period - Fiscal year/period Level 01 (Text)],

right([Fiscal year/period - Fiscal year/period Level 01 (Text)],4) as Year,

Capitalize( If(Index('SP1,SP2,SP3,SP4,Per,', left([Fiscal year/period - Fiscal year/period Level 01 (Text)],3)),'DEC', left([Fiscal year/period - Fiscal year/period Level 01 (Text)],3))) As [Month];

hope this helps

regards

Marco