Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
Trey
Contributor II
Contributor II

Fiscal Year

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? 

1 Solution

Accepted Solutions
anat
Specialist II
Specialist II

YearName ( DateField, 0, 10)

View solution in original post

4 Replies
anat
Specialist II
Specialist II

anat
Specialist II
Specialist II

YearName ( DateField, 0, 10)

adithyapai
Employee
Employee

Trey
Contributor II
Contributor II
Author

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