Calculate Fiscal Year Flags on Master Calendar

[micheledenardi]

Hello experts,

i want to add to my master calendar some fiscal year flags.

My fiscal year start on month 7 (July) so i have to calculate a

1) CurrentFiscalYearFlag so that each date between 01/07/2017 and 30/06/2018 is set to 1, otherwise 0.

2) CurrentFiscalYearToMonthFlag so that each date between 01/07/2017 and the month of current date is set to 1, otherwise 0.

If today is 22/09/2017 i want to obtain exactly this result:

Date	CurrentFiscalYearFlag	CurrentFiscalYearToMonthFlag
01/07/2017	1	1
30/06/2018	1	0
01/07/2018	0	0
30/06/2017	0	0
22/09/2017	1	1
23/09/2017	1	1
30/09/2017	1	1
01/10/2017	1	0

thanks

[Gysbert_Wassenaar · Accepted solution]

Try the InYear and InYearToDate functions.

InYear(Date. Today(), 0, 6)

InYearTodate(Date, Today(), 0, 6)

[siddharth_kulka]

Found an excellent post which was very useful for me.

https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Fiscal-Calendar-Table-load-script/tac-...