Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try something like:
Where Date>=YearStart(Today(),-2,4)