topic Master Calendar linked with yearly fiscal integer in QlikView

Master Calendar linked with yearly fiscal integer

cedriclupo — Mon, 07 Oct 2013 15:36:47 GMT

Hello everyone,

i write to you because I have a problem i'd like to resolve.

I have some date, which belong to a fiscal integer, but the fiscal integer is not a date itself but an integer. (example: 1st april 09= 86, 1st april 10 = 87). this fiscal integer is invremented every april 1st.

However, not all the dates are used so not all of them are linked to the fiscal integer.

Is there a way to link them to the corresponding integer?

I wanted to try intervalmatch but it doesn't seem to work the way I want.

Does anyone have an idea about this?

I hope I express myself ok. Thank you in advance!

Re: Master Calendar linked with yearly fiscal integer

Anonymous — Mon, 07 Oct 2013 15:48:15 GMT

Looks like you have fiscal year starting on April 1st, and 0 is year 1923. Try if this is what you need:

=if(month(Date)>3, year(Date)-1923, year(Date)-1924)

Regards,

Michael

Re: Master Calendar linked with yearly fiscal integer

cedriclupo — Mon, 07 Oct 2013 16:12:42 GMT

Thanks for your answer Michael.

Your answer will work but the fiscal integer is in the main table and not in the calendar, I will have data redundancy in this case (even if in QV it does not really matter i guess).

I tried linking the tables with a monthstart instead of linking with the whole date. It seems to work so far, i wonder if it will cause problems later

Regards,

cedric