topic Re: Missing Values in QlikView https://community.qlik.com/t5/QlikView/Missing-Values/m-p/1116391#M901126 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; A,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; B,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; C,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; If(Len(Trim(C)),C, peek(D)) as D</P><P>FROM</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...source...</P><P>;</P></BODY></HTML> Thu, 21 Jul 2016 11:37:03 GMT Gysbert_Wassenaar 2016-07-21T11:37:03Z Missing Values https://community.qlik.com/t5/QlikView/Missing-Values/m-p/1116389#M901124 <HTML><HEAD></HEAD><BODY><P>How to fill missing values with the latest populated value (case when the previous value is also missing)?</P><P>Eg IF I have table like this</P><P></P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp; C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D(to be filled)</P><P>a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; t&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; u&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">w&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</SPAN></P><P>e&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; y&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; z&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P></P><P>The data in the column <STRONG>D</STRONG> is to be filled using the column <STRONG>C . How can I do this ?</STRONG></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Missing-Values/m-p/1116389#M901124 2020-11-25T16:16:04Z Re: Missing Values https://community.qlik.com/t5/QlikView/Missing-Values/m-p/1116390#M901125 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A,B,C,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(Len(trim(C))=0, Peek(<STRONG>D</STRONG>), C) as D</P><P>From &lt;&gt;:</P></BODY></HTML> Thu, 21 Jul 2016 11:34:49 GMT https://community.qlik.com/t5/QlikView/Missing-Values/m-p/1116390#M901125 tresB 2016-07-21T11:34:49Z Re: Missing Values https://community.qlik.com/t5/QlikView/Missing-Values/m-p/1116391#M901126 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; A,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; B,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; C,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; If(Len(Trim(C)),C, peek(D)) as D</P><P>FROM</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...source...</P><P>;</P></BODY></HTML> Thu, 21 Jul 2016 11:37:03 GMT https://community.qlik.com/t5/QlikView/Missing-Values/m-p/1116391#M901126 Gysbert_Wassenaar 2016-07-21T11:37:03Z Re: Missing Values https://community.qlik.com/t5/QlikView/Missing-Values/m-p/1116392#M901127 <HTML><HEAD></HEAD><BODY><P>Sure!&nbsp; I shall try that.</P><P>Thanks for the response <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 21 Jul 2016 11:37:54 GMT https://community.qlik.com/t5/QlikView/Missing-Values/m-p/1116392#M901127 2016-07-21T11:37:54Z Re: Missing Values https://community.qlik.com/t5/QlikView/Missing-Values/m-p/1116393#M901128 <HTML><HEAD></HEAD><BODY><P>Thanks ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 21 Jul 2016 11:40:02 GMT https://community.qlik.com/t5/QlikView/Missing-Values/m-p/1116393#M901128 2016-07-21T11:40:02Z Re: Missing Values https://community.qlik.com/t5/QlikView/Missing-Values/m-p/1116394#M901129 <HTML><HEAD></HEAD><BODY><P>If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).</P><P>If not, please make clear what part of this topic you still need help with <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P></BODY></HTML> Thu, 21 Jul 2016 11:41:13 GMT https://community.qlik.com/t5/QlikView/Missing-Values/m-p/1116394#M901129 oknotsen 2016-07-21T11:41:13Z