topic master calander Issue in QlikView

master calander Issue

Fri, 19 Jun 2015 06:40:35 GMT

Hi All

can any one help on the below problem.

My fiscal year starts at 25/FEB/YYYY and ends at 24/FEB/YYYY how can I generate master calendar for 60 years. and I would like to generate 13 periods for every year. if any days are remaining after 13 periods. remaining days has to add to another period for every 6 years.

how can I generate master calendar on it.

Regards

John

Re: master calander Issue

Peter_Cammaert — Fri, 19 Jun 2015 08:07:41 GMT

what's the period length (365/13 = 28 days or 4 weeks, 1 day left)?

If you want your fiscal year to always start on the same day, you may have 1 or 2 days left every year. Do you want to accumulate them in a separater period every 6 years? In that case, you fiscal year will start to move. After 6 years, your fiscal year will start on the 18th of february.

Peter

Re: master calander Issue

Fri, 19 Jun 2015 09:24:56 GMT

Yes Peter Your correct. that's what I want. can you Please help me on this.

period length 365/13 = 28 days.1 day left. sum up these days at the 6th year and need to show 14 period instead of 13 periods.