Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Dolly123
Creator II

Data load editor

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

6 Replies
MayilVahanan

Hi

Try like 

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Dolly123
Creator II
Author

hi

where i have to right this 

what is ursources ?

Dolly123
Creator II
Author

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Dolly123
Creator II
Author

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
Champion III

as below

 

TableName:

Load field1,field2,.....datefield

From XyzSource

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.