Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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.