Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
yurgelmartina
Contributor
Contributor

Master Calendar - Reference Day

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!

0 Replies