Discussion board where members can learn more about Qlik Sense App Development and Usage.
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:
Go to Solution.
Try the InYear and InYearToDate functions.
InYear(Date. Today(), 0, 6)
InYearTodate(Date, Today(), 0, 6)