Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

micheledenardi
Valued Contributor

Calculate Fiscal Year Flags on Master Calendar

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:

DateCurrentFiscalYearFlag
CurrentFiscalYearToMonthFlag
01/07/201711
30/06/201810
01/07/201800
30/06/201700
22/09/201711
23/09/201711
30/09/201711
01/10/201710

thanks

1 Solution

Accepted Solutions

Re: Calculate Fiscal Year Flags on Master Calendar

Try the InYear and InYearToDate functions.

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

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


talk is cheap, supply exceeds demand
1 Reply

Re: Calculate Fiscal Year Flags on Master Calendar

Try the InYear and InYearToDate functions.

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

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


talk is cheap, supply exceeds demand