Create a Bookmark on the current FY so that that next FY will update automatically

[Qlikuser09]

Create a Bookmark on the current FY so that that next FY will update automatically

[CezarioAbrantes]

=YourYearField=Year(Today())

[Qlikuser09]

Thanks, I was able to get the Current Year , but i wanted to get the current Fiscal Years data in the Book mark, 

For example my FiscalYearStarts on month 9 and ends on month 8. I also have a Month Year filter field to filter on

[CezarioAbrantes]

You can use YearStart to create a field in script do get it done:

Year(YearStart(Date,0,9))

You can also offset the year:

Year(YearStart(Date,-1,9))

Documentation:
https://help.qlik.com/en-us/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunc...

Regards

Cezário

[Lokesh_5045]

My fiscal year starts from April to Mar. I am using following codes for my bookmarks. Based on this, you can change your code according to your start and end of fiscal year.

If you fiscal year format is just like year, lets say FY 2023 (Apr 23 to Mar 24), then
'FY'&' '&Year(AddMonths(Today()),-3))

If your Fiscal year format is like FY 23-24, then
'FY ' & Right(Year(YearStart(today(),0,4)),2)&'-'&Right(Year(YearEnd(today(),0,4)),2)