topic Re: How to create a calendar in QlikView

How to create a calendar

Anonymous — Wed, 13 Aug 2014 22:34:35 GMT

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);

Re: How to create a calendar

Michael_Tarallo — Wed, 13 Aug 2014 22:56:39 GMT

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

Creating A Master Calendar

Mike

Re: How to create a calendar

Anonymous — Wed, 13 Aug 2014 23:22:23 GMT

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

Re: How to create a calendar

Michael_Tarallo — Wed, 13 Aug 2014 23:24:51 GMT

Great to hear, have a great night.