topic Re: 5 years filter in Script level(Current year to next 5 years) in QlikView

5 years filter in Script level(Current year to next 5 years)

Abhi999 — Wed, 25 Nov 2020 16:16:04 GMT

in Date filed i have years from 2010 to 2040 but i want only from year(today()) to next five years.

i have tried
year( if("Date"<=AddYears(Today(),5),"Date")) as RequiredYear.

But this logic is giving years from 2010 to 2025.i am expecting 2020 to 202

Re: 5 years filter in Script level(Current year to next 5 years)

kaushiknsolanki — Mon, 17 Feb 2020 17:03:16 GMT

Hi,

Try this.

Load * from xyz where (Year(Date) >= Year(Today()) and Year(Date) <= Addyears(Today(),5));

Re: 5 years filter in Script level(Current year to next 5 years)

Brett_Bleess — Wed, 11 Mar 2020 20:03:43 GMT

Did Kaushik's suggestion work for you? If so, do not forget to close out your thread by returning to the post and on his post, use the Accept as Solution button to mark that as the solution to give him credit and let other Members know that it worked. If you did something different, consider posting that, and then mark that as the solution to close the thread, and if you are still working on things, leave an update.

Regards,
Brett