Hi
Currently I am working on a qlikview app that reads in an agency name and then maps their status as either C or NC
MapAgency:
Mapping
LOAD AgencyName, Status
FROM ...Agency.xlsx
and then in my load statement
APPLYMAP('MapAgency',[Source],null()) as [Agency Type]
I have now been asked to develop further where based on a date an agency can change status.
For example in spreadsheet attached Agency1 will always be C as the date field is empty so it keeps its original status, whereas Agency2 starts of as NC and then from 1st Feb 23 the status will be shown as C so any historic data before 01/02/2023 for Agency2 will be shown as NC and any data after this date will be shown as C.
The logic should cover every AgencyName should be assigned their status from column B initially and then need to do a check is todays date > Date (column c) if yes then Status becomes New Status if no or date is blank then Status does not change
Any help greatly appreciated
