
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Try like
Load * from ursource where Match(Year(Date) , Year(Today()), Year(Today())-1);
Please close the thread by marking correct answer & give likes if you like the post.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
where i have to right this
what is ursources ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i need full date from 2022 - 2023 with dd/mm/yyyy
not only year

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Please close the thread by marking correct answer & give likes if you like the post.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
as below
TableName:
Load field1,field2,.....datefield
From XyzSource
WHERE YEAR(datefield)>=YEAR(Today())-1;
If a post helps to resolve your issue, please accept it as a Solution.
