Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
hamza99a
Creator II
Creator II

max date from last year

Hello all,

I am using qlik sense scripting and what I am trying to do is to load in the last available date from last year. For example in my folder from which I am pulling the last data for the year 2017 is december 29. What I want to do is import this file. Also my files are stored in the folder as  " employee_20171229.csv "

Is there a function for finding this day and loading it in. Thank you!

2 Replies
MarioCenteno
Creator III
Creator III

Try

Declare script

let vPriorYearDate = '=date(addyears(max(Field_date),-1),' & chr(39) & 'DD MMM YYYY' & chr(39) & ')';

hamza99a
Creator II
Creator II
Author

that did not work but thanks for the response