Fiscal Calendar

Fri, 19 Feb 2016 07:59:59 GMT

Hi Community

Can anyone please assist me , I am building a calendar with a switch between fiscal and Normal calendar . The requirement For the Fiscal Calendar is that the Year starts on July and End June on the following Year , So the Issue is that when we reach December , it doesn’t go on and pick January as my July it stops in December . On the Attached Screenshot I selected 2015 , it ends on 201606 which is December so I want it to even go to 201607 which is January on the normal Calendar etc. .

num((if(Month(ArTrnDetail.InvoiceDate) > 6 , year(ArTrnDetail.InvoiceDate)+1))&num(if(Month(ArTrnDetail.InvoiceDate) > 6 , Month(ArTrnDetail.InvoiceDate) - 6),'00')) AS Fin_YEAR_MONTH,

num((if(Month(ArTrnDetail.InvoiceDate) > 6, year(ArTrnDetail.InvoiceDate)+1)-1)&num(if(Month(ArTrnDetail.InvoiceDate) > 6, Month(ArTrnDetail.InvoiceDate) - 6) ,'00')) AS Fin_YEAR_MONTH_PREVIOUS,

Re: Fiscal Calendar

sunny_talwar — Fri, 19 Feb 2016 10:44:05 GMT

Chech the code given by jagan‌ here: Fiscal and Standard Calendar generation

topic Fiscal Calendar in QlikView

Fiscal Calendar

Re: Fiscal Calendar