Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Date Manipulation

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.

1 Solution

Accepted Solutions
Highlighted

Re: Date Manipulation

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;

View solution in original post

3 Replies
Highlighted
Specialist III
Specialist III

Re: Date Manipulation

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

Highlighted

Re: Date Manipulation

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;

View solution in original post

Highlighted
Creator III
Creator III

Re: Date Manipulation

Thank you Sunny. It works