Left date to be decided based on the last Month his or her paid Month
I need to decide the left Month/Year of an employee based on the last Month his/her payment was done. As for my data, I have only 6 Months paid details. Some employees have received their payment up to last Months which is the Month of June as for my data (I have loaded only up to June). These employees are active who are still in the employment but if some one has got his her payment up to Feb, then his date of resignation should be marked as 02/01/2019. If his last paid date is April 2019, his left date should be 04/01/2019 etc. If this can be done in the front end (in the script) with a created flag fine.
I cannot open & see your data structure as I have no qlik view licenses.Could you please copy your script in the body of the mail or in a note pad & send. Since I have no much idea in the script design, please let me know the step by step arrangement that is to be performed.