topic Re: Load value in previous ROW if Null in QlikView https://community.qlik.com/t5/QlikView/Load-value-in-previous-ROW-if-Null/m-p/517019#M193004 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Wed, 15 Jan 2014 15:33:04 GMT Gysbert_Wassenaar 2014-01-15T15:33:04Z Load value in previous ROW if Null https://community.qlik.com/t5/QlikView/Load-value-in-previous-ROW-if-Null/m-p/517016#M193001 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>In Attachment you'll find example for work. Sheet 1 is loaded data. Sheet 2 is what I need to make in QVD table.</P><P></P><P>QUESTION:</P><P>How can I load data to spec fields in&nbsp; row with data from previous row if there is no data for date?</P></BODY></HTML> Wed, 15 Jan 2014 14:53:52 GMT https://community.qlik.com/t5/QlikView/Load-value-in-previous-ROW-if-Null/m-p/517016#M193001 stantrolav 2014-01-15T14:53:52Z Re: Load value in previous ROW if Null https://community.qlik.com/t5/QlikView/Load-value-in-previous-ROW-if-Null/m-p/517017#M193002 <HTML><HEAD></HEAD><BODY><P>First you have to generate the rows, then fill the values.</P><P></P><P>1) Generate calendar table.( for each "Agr", get min(Date) and max(Date) values and generate Date rows)</P><P>2) Join to current table</P><P>3) Using PEEK(), get values from previous row if current has null values.</P></BODY></HTML> Wed, 15 Jan 2014 15:04:32 GMT https://community.qlik.com/t5/QlikView/Load-value-in-previous-ROW-if-Null/m-p/517017#M193002 luciancotea 2014-01-15T15:04:32Z Re: Load value in previous ROW if Null https://community.qlik.com/t5/QlikView/Load-value-in-previous-ROW-if-Null/m-p/517018#M193003 <HTML><HEAD></HEAD><BODY><P>Could you write an example of Using PEEK() for my variant?</P></BODY></HTML> Wed, 15 Jan 2014 15:06:45 GMT https://community.qlik.com/t5/QlikView/Load-value-in-previous-ROW-if-Null/m-p/517018#M193003 stantrolav 2014-01-15T15:06:45Z Re: Load value in previous ROW if Null https://community.qlik.com/t5/QlikView/Load-value-in-previous-ROW-if-Null/m-p/517019#M193004 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Wed, 15 Jan 2014 15:33:04 GMT https://community.qlik.com/t5/QlikView/Load-value-in-previous-ROW-if-Null/m-p/517019#M193004 Gysbert_Wassenaar 2014-01-15T15:33:04Z