topic Fill between date (load script) in QlikView https://community.qlik.com/t5/QlikView/Fill-between-date-load-script/m-p/436888#M1152517 <HTML><HEAD></HEAD><BODY><P>I have this type of data format.</P><P></P><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Date(DD/MM/YYYY)</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>1/1/2013</TD><TD>3</TD></TR><TR><TD>1/2/2013</TD><TD>4</TD></TR><TR><TD>1/3/2013</TD><TD>6</TD></TR><TR><TD>1/6/2013</TD><TD>9</TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV> </DIV><DIV>I want the table to be in the below mentioned format.</DIV><DIV> </DIV><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG><STRONG>Date(DD/MM/YYYY)</STRONG></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>1/1/2013</TD><TD>3</TD></TR><TR><TD>1/2/2013</TD><TD>4</TD></TR><TR><TD>1/3/2013</TD><TD>6</TD></TR><TR><TD>1/4/2013</TD><TD>6</TD></TR><TR><TD>1/5/2013</TD><TD>6</TD></TR><TR><TD>1/6/2013</TD><TD>9</TD></TR></TBODY></TABLE></DIV></BODY></HTML> Tue, 04 Jun 2013 13:07:27 GMT kumarnatarajan 2013-06-04T13:07:27Z Fill between date (load script) https://community.qlik.com/t5/QlikView/Fill-between-date-load-script/m-p/436888#M1152517 <HTML><HEAD></HEAD><BODY><P>I have this type of data format.</P><P></P><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Date(DD/MM/YYYY)</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>1/1/2013</TD><TD>3</TD></TR><TR><TD>1/2/2013</TD><TD>4</TD></TR><TR><TD>1/3/2013</TD><TD>6</TD></TR><TR><TD>1/6/2013</TD><TD>9</TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV> </DIV><DIV>I want the table to be in the below mentioned format.</DIV><DIV> </DIV><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG><STRONG>Date(DD/MM/YYYY)</STRONG></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>1/1/2013</TD><TD>3</TD></TR><TR><TD>1/2/2013</TD><TD>4</TD></TR><TR><TD>1/3/2013</TD><TD>6</TD></TR><TR><TD>1/4/2013</TD><TD>6</TD></TR><TR><TD>1/5/2013</TD><TD>6</TD></TR><TR><TD>1/6/2013</TD><TD>9</TD></TR></TBODY></TABLE></DIV></BODY></HTML> Tue, 04 Jun 2013 13:07:27 GMT https://community.qlik.com/t5/QlikView/Fill-between-date-load-script/m-p/436888#M1152517 kumarnatarajan 2013-06-04T13:07:27Z Re: Fill between date (load script) https://community.qlik.com/t5/QlikView/Fill-between-date-load-script/m-p/436889#M1152518 <HTML><HEAD></HEAD><BODY><P>See <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field">this blog post</A>.</P></BODY></HTML> Tue, 04 Jun 2013 13:24:33 GMT https://community.qlik.com/t5/QlikView/Fill-between-date-load-script/m-p/436889#M1152518 Gysbert_Wassenaar 2013-06-04T13:24:33Z Re: Fill between date (load script) https://community.qlik.com/t5/QlikView/Fill-between-date-load-script/m-p/436890#M1152519 <HTML><HEAD></HEAD><BODY><P><SPAN>You might want to try Qlikview Components (QVC) </SPAN><A class="jive-link-external-small" href="http://qlikviewcomponents.org">http://qlikviewcomponents.org</A><SPAN> for this.</SPAN></P><P></P><P>The QVC Call would be:</P><P></P><P> <SPAN style="font-family: 'courier new', courier;">CALL Qvc.ExpandInterval('MyTable', 'Date');</SPAN></P><P></P><P>-Rob</P></BODY></HTML> Tue, 04 Jun 2013 15:10:56 GMT https://community.qlik.com/t5/QlikView/Fill-between-date-load-script/m-p/436890#M1152519 rwunderlich 2013-06-04T15:10:56Z