Fill between date (load script)

[kumarnatarajan]

I have this type of data format.

Date(DD/MM/YYYY)	Value
1/1/2013	3
1/2/2013	4
1/3/2013	6
1/6/2013	9

I want the table to be in the below mentioned format.

Date(DD/MM/YYYY)	Value
1/1/2013	3
1/2/2013	4
1/3/2013	6
1/4/2013	6
1/5/2013	6
1/6/2013	9

[Gysbert_Wassenaar · Accepted solution]

See this blog post.

[rwunderlich]

You might want to try Qlikview Components (QVC) http://qlikviewcomponents.org for this.

The QVC Call would be:

CALL Qvc.ExpandInterval('MyTable', 'Date');

-Rob