topic Re: Filling the gap in QlikView

Filling the gap

vesiletaskiran — Mon, 17 Sep 2018 12:49:50 GMT

Hello All,

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 ;

Report 1

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.

Re: Filling the gap

vesiletaskiran — Mon, 17 Sep 2018 12:56:35 GMT

By the way this example is transposed to show expected output more clearly,

My original source has report_id, date, report_status

Re: Filling the gap

Anil_Babu_Samineni — Mon, 17 Sep 2018 14:12:33 GMT

You can use After / Before functions??

Re: Filling the gap

vesiletaskiran — Mon, 17 Sep 2018 14:18:55 GMT

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