Discussion Board for collaboration on QlikView Scripting.
I am trying to find the start and end dates for StaffNo based on a sequence of consecutive dates.
From below table, StaffNo and Work_Date is the input. Output required from script is Start_Date, End_Date
Hi I use scripts to meet your requirements.
View solution in original post
This works perfectly. Thank you very much.