topic Re: Add a Month and Week index to Master Calendar in QlikView

Add a Month and Week index to Master Calendar

regowins — Wed, 04 Dec 2013 02:48:18 GMT

Hi, is there a quick way to add a month and week index to the below master calendar ? For now i only have the date index but I would like to add a month and week index.

TempCalendar:

LOAD
$(varMaxDate) - RowNo() +1 as DateNumber,
Date($(varMaxDate) - RowNo() + 1) as TempDate,
RowNo() as dateIndex
AutoGenerate 1
While $(varMinDate) + IterNo()-1<= $(varMaxDate);

Thanks for the help!

Re: Add a Month and Week index to Master Calendar

jagan — Wed, 04 Dec 2013 03:21:24 GMT

Hi Ashwin,

Try this

TempCalendar:

LOAD

Month(TempDate) AS Month,

Week(TempDate) AS Week;

Regards,

Jagan.

Re: Add a Month and Week index to Master Calendar

Wed, 04 Dec 2013 04:29:25 GMT

Try with Month & Week functions in the script.

Re: Add a Month and Week index to Master Calendar

regowins — Wed, 04 Dec 2013 05:33:59 GMT

Hi Jagan,

Yes, I already have this setup. I was looking for a sequential index with out it being reset in a new year. With current method I would only get 52 weeks for every year. i would like the index to continue on past 52 weeks for the date range. I hope that makes sense. I think I may have to create a separte calendar using autogenerate.

Re: Add a Month and Week index to Master Calendar

hic — Wed, 04 Dec 2013 07:08:57 GMT

You should not create a new table for this. There are many ways to create sequential numbers inside existing master calendar, e.g.

12*Year(Date) + Month(Date) as SeqMonth

MonthStart(Date) as MonthStartDate

Div(Date,7) as SeqWeekNumber

HIC

Re: Add a Month and Week index to Master Calendar

regowins — Thu, 05 Dec 2013 02:44:06 GMT

Thanks! I did not think of this.