Discussion Board for collaboration on QlikView Scripting.
I have a table which logs the changes on the status of every reports. For the dates where there is no change, it must fill the value with the previous available date.
In below example ;
Date 1 to Date 6 : it must return Yes
Date 7 to Date 10: it must return Suspended
Date 11 to Date 14: Yes
and so on.
Could you please support on which method/function must be used?
Thanks in advance.
By the way this example is transposed to show expected output more clearly,
My original source has report_id, date, report_status
You can use After / Before functions??
I am using previous function and while to fill missing dates. i can fill the values before min date and after max update date but it doesnt work in between