Discussion Board for collaboration related to QlikView App Development.
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.
May be something like this:
CrossTable([Billable Month], Data, 2)
LOAD [Project Name],
'Q' & Ceil(Month(Date#([Billable Month], 'MMMM'))/3) as [Billable Quarter]
DROP Table TableName;
View solution in original post
I think you should replace [Billable Month] should be [Project Name] like this:
CrossTable([Project Name], Data, 2)
Read the help page from Qlik:
Thank you Sunny. It works