Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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
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;
Thank you Sunny. It works