topic Re: Date Manipulation in QlikView

Date Manipulation

akpofureenughwu — Thu, 22 Sep 2016 13:38:35 GMT

Good day everyone

I have a data set where I have to use crosstable function to pulll the data.

I need to create quarter functon from the months.

I need help.

Please find the attached file.

For clarify.

Re: Date Manipulation

miguelbraga — Thu, 22 Sep 2016 13:47:52 GMT

Hey there,

I think you should replace [Billable Month] should be [Project Name] like this:

CrossTable([Project Name], Data, 2)

LOAD [Project Name],

Resource,

January,

February,

March,

April,

May,

June,

July,

August,

September,

October,

November,

December

FROM

XXXXXXXX

XXXXXX""E$E£$%%^RYY^UUYU&I

Read the help page from Qlik:

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/ScriptPrefixes/crosstable.htm

Best regards,

D.A. MB

Re: Date Manipulation

sunny_talwar — Thu, 22 Sep 2016 13:49:34 GMT

May be something like this:

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

TableName:

CrossTable([Billable Month], Data, 2)

LOAD [Project Name],

Resource,

January,

February,

March,

April,

May,

June,

July,

August,

September,

October,

November,

December

FROM

XXXXXXXX

XXXXXX""E$E£$%%^RYY^UUYU&I

FinalTable:

LOAD [Project Name],

Resource,

[Billable Month],

Data,

'Q' & Ceil(Month(Date#([Billable Month], 'MMMM'))/3) as [Billable Quarter]

Resident TableName;

DROP Table TableName;

Re: Date Manipulation

akpofureenughwu — Thu, 22 Sep 2016 13:55:53 GMT

Thank you Sunny. It works