topic How to check next field value in QlikView https://community.qlik.com/t5/QlikView/How-to-check-next-field-value/m-p/1281815#M866495 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P>I have following table..</P><P>and I need figure out how to check next value</P><P>If value is 150 and next value is 160 then [Result] must be 0</P><P>If value is 150 and after is something else value from field [Time] must stay same also in field [Result].</P><P></P><TABLE border="1" class="jiveBorder" height="224" style="border: 1px solid rgb(0, 0, 0); width: 481px; height: 192px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Description</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Time</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Result</TH></TR><TR><TD style="padding: 2px;">130</TD><TD style="padding: 2px;">SMT</TD><TD style="padding: 2px;">1,14</TD><TD style="padding: 2px;">1,14</TD></TR><TR><TD style="padding: 2px;">110</TD><TD style="padding: 2px;">Prehandling</TD><TD style="padding: 2px;">3,04</TD><TD style="padding: 2px;">3,01</TD></TR><TR><TD style="padding: 2px;"><STRONG style="color: #ff0000;">150</STRONG></TD><TD style="padding: 2px;"><STRONG style="color: #ff0000;">Manual assembly</STRONG></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>8,44</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>0</STRONG></SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>160</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>Wave soldering</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>1,4</STRONG></SPAN></TD><TD style="padding: 2px;"><STRONG style="color: #ff0000;">0</STRONG></TD></TR><TR><TD style="padding: 2px;">180</TD><TD style="padding: 2px;">Quality Control</TD><TD style="padding: 2px;">1,8</TD><TD style="padding: 2px;">1,8</TD></TR><TR><TD style="padding: 2px;">290</TD><TD style="padding: 2px;">Other testing</TD><TD style="padding: 2px;">1,5</TD><TD style="padding: 2px;">1,5</TD></TR><TR><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>150</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>Manual assembly</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>0,35</STRONG></SPAN></TD><TD style="padding: 2px;"><STRONG style="color: #ff0000;">0,35</STRONG></TD></TR><TR><TD style="padding: 2px;">220</TD><TD style="padding: 2px;">ICT</TD><TD style="padding: 2px;">0,7</TD><TD style="padding: 2px;">0,7</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT jozef_klimo 2020-11-25T16:16:04Z How to check next field value https://community.qlik.com/t5/QlikView/How-to-check-next-field-value/m-p/1281815#M866495 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P>I have following table..</P><P>and I need figure out how to check next value</P><P>If value is 150 and next value is 160 then [Result] must be 0</P><P>If value is 150 and after is something else value from field [Time] must stay same also in field [Result].</P><P></P><TABLE border="1" class="jiveBorder" height="224" style="border: 1px solid rgb(0, 0, 0); width: 481px; height: 192px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Description</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Time</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Result</TH></TR><TR><TD style="padding: 2px;">130</TD><TD style="padding: 2px;">SMT</TD><TD style="padding: 2px;">1,14</TD><TD style="padding: 2px;">1,14</TD></TR><TR><TD style="padding: 2px;">110</TD><TD style="padding: 2px;">Prehandling</TD><TD style="padding: 2px;">3,04</TD><TD style="padding: 2px;">3,01</TD></TR><TR><TD style="padding: 2px;"><STRONG style="color: #ff0000;">150</STRONG></TD><TD style="padding: 2px;"><STRONG style="color: #ff0000;">Manual assembly</STRONG></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>8,44</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>0</STRONG></SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>160</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>Wave soldering</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>1,4</STRONG></SPAN></TD><TD style="padding: 2px;"><STRONG style="color: #ff0000;">0</STRONG></TD></TR><TR><TD style="padding: 2px;">180</TD><TD style="padding: 2px;">Quality Control</TD><TD style="padding: 2px;">1,8</TD><TD style="padding: 2px;">1,8</TD></TR><TR><TD style="padding: 2px;">290</TD><TD style="padding: 2px;">Other testing</TD><TD style="padding: 2px;">1,5</TD><TD style="padding: 2px;">1,5</TD></TR><TR><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>150</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>Manual assembly</STRONG></SPAN></TD><TD style="padding: 2px;"><SPAN style="color: #ff0000;"><STRONG>0,35</STRONG></SPAN></TD><TD style="padding: 2px;"><STRONG style="color: #ff0000;">0,35</STRONG></TD></TR><TR><TD style="padding: 2px;">220</TD><TD style="padding: 2px;">ICT</TD><TD style="padding: 2px;">0,7</TD><TD style="padding: 2px;">0,7</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-check-next-field-value/m-p/1281815#M866495 jozef_klimo 2020-11-25T16:16:04Z Re: How to check next field value https://community.qlik.com/t5/QlikView/How-to-check-next-field-value/m-p/1281816#M866496 <HTML><HEAD></HEAD><BODY><P>I guess you will need to sort in descending order because you cannot check next value in the script, but you can check the previous value using Peek/Previous but use descending sort order</P></BODY></HTML> Mon, 19 Dec 2016 15:51:57 GMT https://community.qlik.com/t5/QlikView/How-to-check-next-field-value/m-p/1281816#M866496 sunny_talwar 2016-12-19T15:51:57Z