Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
baarathi
Creator III
Creator III

Load Past 2 Year Data from current loading date

I'm trying to load past 2 year's data from current date, but i could not get solution from my script.

For Example : If I load on March-12-2018, I want to display data from March-12-2016 to March-12-2018.

4 Replies
MK_QSL
MVP
MVP

From the enclosed files, I can see you don't have data by date. You have monthly data !!

Then how you can manage 12/03/2016 to 12/03/2018???

baarathi
Creator III
Creator III
Author

In manager Excel file there is CreatedOn field, which is a Date Field.

MK_QSL
MVP
MVP

So you want your last three year condition for that field only?

baarathi
Creator III
Creator III
Author

Ya sir, last 2 years condition.