I'm looking to add in the script a bit to categorise as prior year vs current year.
So all my files are labelled the same With the differences being the Month and Year.
What I would like to be able to do is have Qliksense identify that the latest file in date is May 2019, and that is categorised as Current Year, and then have it find the one that's May 2018 and have that categorised as Prior Year so I can compare the two in multiple tables.
I can't seem to find something a previous thread that works/gives me what I need, but I have got Qlik to recognise the May 2019 etc as a date and this is my script to do that.
mapping LOAD *
0, Current Year
-1, Prior Year
MAX(Year) as LatestYear
LEFT JOIN LOAD
applymap('map',Year - LatestYear, null()) as RelYear,
DROP FIELD LatestYear;
??? Celebrating my 300 accepted solution in the Qlik Community ???
Thanks for this, but I'm not sure it will work in the long run, There will be data for every month going back to 2016 and I don't want to have to edit the script every month when this is run, especially as I might not be the one running it each time...