Data load editor

[Dolly123]

I have  data like 2010 - 2023 data

i want to implement only requirement current year and prev year in data load editor 

like fetch date from  2022-2023 only 

not in front end page

[MayilVahanan]

Hi

Try like 

Load * from ursource where Match(Year(Date) , Year(Today()), Year(Today())-1);

[Dolly123]

hi

where i have to right this 

what is ursources ?

[Dolly123]

i need full date from 2022 - 2023 with dd/mm/yyyy

not only year

[MayilVahanan]

UrSource is "Either qvd, xls, csv, ....) 

Year(Date) -- Check what is the year based on date column and not alter any of ur source columns. 

Try to Understand the concept in Qlik

[Dolly123]

i have date column which is dd/mm/yyyy

i need date column from prevous and current for dd/mm/yyyy

if we will use year(date) will get only year

how we can do ?

[vinieme12]

as below

TableName:

Load field1,field2,.....datefield

From XyzSource

WHERE YEAR(datefield)>=YEAR(Today())-1;