topic SQL Rolling 3 years in App Development

SQL Rolling 3 years

hjm35055 — Tue, 23 Oct 2018 20:37:36 GMT

Hi,

I am working in Qlik Sense and pulling data from a SQL database. I am trying to limit the SQL script to bring in the last 3 years worth of data based off of the field "oe-date-ent" (not shown). Anyone know SQL and know what my where clause would be?

Thank you!

Re: SQL Rolling 3 years

achettipalli — Tue, 23 Oct 2018 22:01:26 GMT

Assuming your field "oe-date-ent" is a date column.

Let Vdatefilter=date(AddYears(today(),-3),'MM/dd/YYYY') // you can use max(oe-date-ent) instead of Today() here, //but you've to load it before the script.

Load

Field1,

field2...

from...

where oe-date-ent >=$(Vdatefilter);