Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
vesiletaskiran
New Contributor III

Filling the gap

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?

example.jpg

Thanks in advance.

3 Replies
vesiletaskiran
New Contributor III

Re: Filling the gap

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

My original source has report_id, date, report_status

Highlighted

Re: Filling the gap

You can use After / Before functions??

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
vesiletaskiran
New Contributor III

Re: Filling the gap

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