where condition ?

[Dolly123]

Extract data for 2 years data in qliksense using where condition in code.

[Prem0212]

you can use the where condition like this in the Data load editor

WHERE [date field] >= 'start date' and [date field] <= 'end date';

[Prem0212]

You can also use this condition and it will extract the data for past 2 years from now

WHERE [Ship Date] >= YearStart(AddYears(Today(), -2)) and [Ship Date] <= Today();

[MayilVahanan]

Hi

Try like below

Where Year(DateField) >= Year(Today())-2;

[BrunPierre]

These are for dynamic loading.

Current year to next 2 years

 Where Year(DateField) >= Year(Today()) and Year(DateField) <= Year(Addyears(Today(),2));

From the last 2 years to the current year

 Where Year(DateField) >= Year(Addyears(Today(),-2)) and Year(DateField) <= Year(Today());