Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
aboliogale
Contributor II
Contributor II

Fiscal Year - In load script

Hi all,

I want to fetch the data for last 3 fiscal years from QVD. e.g. current fiscal year is 2020-2021, so I want to write a condition in where clause in such a way that I will get data from 2018 April month onward. 

From April 2021, it should fetch data from 2019 Apr onward.

In the QVD, i have date field. Any suggestion what should I write in the where clause to filter the data for last 3 financial years?

Thank you in advanced 🙂 

#FiscalYear #Date #Qlikview #Script

Labels (3)
1 Reply
tresesco
MVP
MVP

Try something like:

Where Date>=YearStart(Today(),-2,4)