Master Calendar - Reference Day

yurgelmartina — Wed, 25 Apr 2018 04:12:47 GMT

Hi Guys,

I have been studying a few codes for creating a master calendar.

Could you please help me develop this logic, not sure if it is complex or not...

Case:

14/05/2017 Sunday was Mother's Day (holiday). There was a peak of sells in the previous day, Saturday - 13/05/2017.

I need to set this variable (it can be manually) on my script and then make it a reference and create a calendar from this reference date.

Example:

Create a table with the weeks:

Interval is always Sunday - Saturday (Peak Day)

(...)Rest of the year(...)

(...) - Peak Week -4

(...) - Peak Week -3

(...) - Peak Week -2

1/05/2017 - 6/05/2017 - Peak Week -1

7/05/2017-13/05/2017 - Peak Week

14/05/2017 - 20/05/2017 - Peak Week +1

(...) - Peak Week +2

(...) - Peak Week +4

(...) - Peak Week +3

(...)Rest of the year(...)

Create a table with Saturdays:

(...)Rest of the year(...)

6 - Saturday Peak -1

13 - Saturday Peak

20 - Saturday Peak -1

(...)Rest of the year(...)

Do you have any idea or heard someone that needed to do the same for Seasonality Analysis?

Thanks!

topic Master Calendar - Reference Day in QlikView