How to create a calendar

[Anonymous]

Hi I am brand new to qlikview and I have a question i am hoping I can get some help with. I tried the following in the script to have dates for the past 2 years. but it gave me error. Any help will be much appreciated.

let start = floor(date(AddMonths(today(),-24));

let end = floor(date(Today()));

let numofdays = end - start+1;

Time_table:

LOAD

Distinct

AutoNumberHash128(MonthName(date($(start)+ RowNo() -1))) as Month_Seq,

MonthName(date($(start)+ RowNo() -1)) as Month_name,

MonthName(date($(start)+ RowNo() -1)) as My_month,

date($(start)+ RowNo() -1)as Date

AutoGenerate $(numofdays);

[Michael_Tarallo]

Hi John - check this out and let us know if it helps you.

Creating A Master Calendar

Mike

[Anonymous · Accepted solution]

Thanks Mike. That video looks really good and important. I will  check it out. However I found the error in my script.

  let start = floor(date(AddMonths(today(),-24));   in this line, I had missed a 'bracket' or parenthesis. So altogether it should have 3 of them, which I added and it worked! Thanks again

[Michael_Tarallo]

Great to hear, have a great night.