Fiscal Year

[Trey]

Hi - I'm somewhat new to QS but have made a lot of headway. I have 3000+ lines of data, and each line has a date (DD/MM/YYY). I have set up filter buttons that can filter by calendar year while I have another filter button that can filter by month. Those expressions were pretty easy to write.

Now I'm trying to set up a new filter button that will filter by fiscal year. For instance, I want to have the option to filter Oct 2020 through Sep 2021 and name this 2020 - 2021.

I'm having trouble writing an expression to do this. Any recommendations? 

[anat]

can you try like :YearName ( DateField, 0, 4)

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd....

[anat · Accepted solution]

YearName ( DateField, 0, 10)

[adithyapai]

Check out this blogpost 

https://community.qlik.com/t5/Qlik-Design-Blog/Fiscal-Year/ba-p/1472103

[Trey]

Thanks! This worked perfectly and was way easier than I expected the answer to be. I appreciate your help.