topic Re: Fiscal Calendar with shift in months in QlikView

Fiscal Calendar with shift in months

peschu123 — Tue, 22 Oct 2013 12:38:38 GMT

Hi,

I would like to create a fiscal calendar, generated from min/max values of a field. I found several ways/solutions and it works fine.

To make this complete I have to integrate a shift in my fiscal periods.

To say it in pseudo script:

(Assuming every day is a workday)

Start fp = Monthstart - 2 Days ... or in other words: The last 2 days of the previous month belong to the actual fiscal period.

And because, this would be too easy there are some constraints or side-conditions:

Saturday,Sunday and Holidays increase the days to be shifted. At the moment I flag the row with 2 fields "Isweekend" and "Isholiday".

Example:

March 2013 (01.03.2013 - 31.01.2013)

FP12 starts at 28.02.2013

FP12 ends at 26.03.2013

FP01 starts at 27.03.2013

29.03. Holiday

30.03. Saturday

31.03. Sunday & Holiday

01.04. Holiday (should not matter)

So I have to check if it is weekend or holiday or both and define the shift accordingly...

My brain is melting away, if someone has a solution or a hint I would really appreciate it.

Thank you,

Peter

Re: Fiscal Calendar with shift in months

tresB — Tue, 22 Oct 2013 12:43:48 GMT

Have a look at this design blog post and Fiscal Year

Re: Fiscal Calendar with shift in months

peschu123 — Tue, 22 Oct 2013 12:56:14 GMT

hmm that defines a new start etc. but my main problem is that there could be possibly every month a different start date, depending on holidays and weekends?

Or am I missing something in this post?

Re: Fiscal Calendar with shift in months

peschu123 — Fri, 25 Oct 2013 07:32:19 GMT

Hi, nobody an idea how to solve this? Impossible?

The main problem is, to determine when the fiscal month starts ends, depending on weekends and holidays...

If somebody has an example or could just point me in the right direction to solve this would be great. Its not urgent, but I would like to delete a point from my (very long) todo list.

Thank you in advance and best regards,

Peter

Re: Fiscal Calendar with shift in months

hic — Tue, 19 Nov 2013 19:54:07 GMT

There are very few data modeling problems that you cannot solve with QlikView...

I am sure that there is a simpler solution, but here is one solution anyway.

HIC

Re: Fiscal Calendar with shift in months

peschu123 — Wed, 20 Nov 2013 08:51:43 GMT

Hi Henric,

Thank you very much its quite impressive. To have a way in the head and to transform it into a load script are 2 different things.

I think this will work quite well for me.

Thank you very much.