topic Re: Logic to use previous row issue in QlikView https://community.qlik.com/t5/QlikView/Logic-to-use-previous-row-issue/m-p/1292451#M853257 <HTML><HEAD></HEAD><BODY><P>take a look at this post <A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A> </P></BODY></HTML> Thu, 16 Feb 2017 18:26:02 GMT albertovarela 2017-02-16T18:26:02Z Logic to use previous row issue https://community.qlik.com/t5/QlikView/Logic-to-use-previous-row-issue/m-p/1292450#M853256 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>I have the following table</P><P></P><P>ColumnA&nbsp;&nbsp;&nbsp;&nbsp; ColumnB&nbsp;&nbsp;&nbsp;&nbsp; ColumnC&nbsp;&nbsp;&nbsp;&nbsp; Question&nbsp;&nbsp;&nbsp;&nbsp; SubQ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Answer</P><P>John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.1.1.1&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; Hello&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hi</P><P>John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.1.1.1&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; Where&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.1.1.1&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; is Home&nbsp;&nbsp;&nbsp;&nbsp; Atlanta</P><P><SPAN style="font-size: 13.3333px;">John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.1.1.1&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; is Work&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Downtown</SPAN></P><P><SPAN style="font-size: 13.3333px;">John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.1.1.1&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; is School&nbsp;&nbsp;&nbsp; Kennesaw</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>as you noticed on Question column.. sometime it might have sub questions and they are listed on the next rows and also the subQ is used..&nbsp; </P><P></P><P>I need to change the structure a little bit on the script side as follow</P><P></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">ColumnA&nbsp;&nbsp;&nbsp;&nbsp; ColumnB&nbsp;&nbsp;&nbsp;&nbsp; ColumnC&nbsp;&nbsp;&nbsp;&nbsp; Question&nbsp;&nbsp;&nbsp;&nbsp; SubQ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Answer</SPAN></P><P style="font-size: 13.3333px;">John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.1.1.1&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; Hello&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Good</P><P style="font-size: 13.3333px;">John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.1.1.1&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; Where&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; is Home&nbsp;&nbsp;&nbsp;&nbsp; Atlanta</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.1.1.1&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; Where&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; is Work&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Downtown</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.1.1.1&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2016&nbsp;&nbsp;&nbsp;&nbsp; Where&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; is School&nbsp;&nbsp;&nbsp; Kennesaw</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Logic-to-use-previous-row-issue/m-p/1292450#M853256 alec1982 2020-11-25T16:16:04Z Re: Logic to use previous row issue https://community.qlik.com/t5/QlikView/Logic-to-use-previous-row-issue/m-p/1292451#M853257 <HTML><HEAD></HEAD><BODY><P>take a look at this post <A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A> </P></BODY></HTML> Thu, 16 Feb 2017 18:26:02 GMT https://community.qlik.com/t5/QlikView/Logic-to-use-previous-row-issue/m-p/1292451#M853257 albertovarela 2017-02-16T18:26:02Z Re: Logic to use previous row issue https://community.qlik.com/t5/QlikView/Logic-to-use-previous-row-issue/m-p/1292452#M853259 <HTML><HEAD></HEAD><BODY><P>Something like this would work<STRONG><BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>If(ColumnA=peek(ColumnA),</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; If(ISNULL(Question),</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(ISNULL(peek(Question)),peek(<STRONG style="font-size: 13.3333px;">NEWFIELD</STRONG>),peek(Question)),Question),Question) as NEWFIELD</STRONG></P></BODY></HTML> Thu, 16 Feb 2017 19:11:47 GMT https://community.qlik.com/t5/QlikView/Logic-to-use-previous-row-issue/m-p/1292452#M853259 aarkay29 2017-02-16T19:11:47Z Re: Logic to use previous row issue https://community.qlik.com/t5/QlikView/Logic-to-use-previous-row-issue/m-p/1292453#M853261 <HTML><HEAD></HEAD><BODY><P>Hi Harfoush,</P><P></P><P>Check the attached APP</P></BODY></HTML> Fri, 17 Feb 2017 15:30:55 GMT https://community.qlik.com/t5/QlikView/Logic-to-use-previous-row-issue/m-p/1292453#M853261 Anonymous 2017-02-17T15:30:55Z