Date Manipulation

[akpofureenughwu]

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.

[miguelbraga]

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

[sunny_talwar · Accepted solution]

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;

[akpofureenughwu]

Thank you Sunny. It works