topic Re: Master /Fiscal Calendar in QlikView

Master /Fiscal Calendar

jjking58 — Wed, 25 Nov 2020 16:16:04 GMT

I created a Master Calendar and added Fiscal fields (Year,Month,Quarter.). Neither calendar seems to be working correctly.

I wanted the Fiscal period to start in April and include only years 2015, 2016.

The results are pulling all dates for years 2013,2014,2015 and the fiscal months are not working at all.

The following is the Master Calendar code and the table file.

The (IHIDAT is formatted in the table(Inv_Header) (as YYYYMMDD) if this helps

Please advise

Thanks,

Jim

Re: Master /Fiscal Calendar

vinieme12 — Mon, 19 Dec 2016 15:34:46 GMT

try this one

Fiscal and Standard Calendar generation

Re: Master /Fiscal Calendar

jjking58 — Mon, 19 Dec 2016 15:40:21 GMT

I've tried this and it seemed to work for the current fiscal year, but i was unable to generate the previous year correctly. Especially when displaying 2016 Apr-Jan and then 2015 Apr-Jan

Can you explain how to do this?

Thanks