topic Re: Add date to data in the script in QlikView

Add date to data in the script

Thu, 28 Nov 2013 22:38:16 GMT

HI,

I need to analyze the model by year quarters and months.

Sales table between 2007 - 2010 and the budget table should be the same every year.

Can someone show me how to add it to the script?

Fri, 29 Nov 2013 01:23:48 GMT

You can create the Year field by : Year(DateField) AS Year

and Quarter by: Q & Ceil(Month(DateField)/3) AS Quarter

Fri, 29 Nov 2013 01:30:16 GMT

Or You can create the Master Calender Table and connected the Calender Table through your Date field.

CALENDAR:

LOAD DATEFIELD ,

Year(DATEFIELD) AS YEAR,

Month(DATEFIELD) AS MONTH

'Q' & Ceil(Month(DATEFIELD)/3) AS QUARTER,

Week(DATEFIELD) AS WEEK

;

LOAD DISTINCT DATEFIELD

Resident From SALES_TABLE;

You can any other calender fields to CALENDAR table if you need.