Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try
Declare script
let vPriorYearDate = '=date(addyears(max(Field_date),-1),' & chr(39) & 'DD MMM YYYY' & chr(39) & ')';
that did not work but thanks for the response