topic Peek or previous... in QlikView https://community.qlik.com/t5/QlikView/Peek-or-previous/m-p/1287986#M403135 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="200" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 1px solid rgb(0, 0, 0); width: 226px; height: 180px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">rownum</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Counter</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Need<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Qlik does this</STRONG></TH></TR><TR><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>2</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>3</TD><TD>2</TD><TD>0</TD><TD>1</TD></TR><TR><TD>4</TD><TD>3</TD><TD>1</TD><TD>1</TD></TR><TR><TD>5</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>6</TD><TD>2</TD><TD>1</TD><TD>1</TD></TR><TR><TD>7</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P></P><P>I want to flag the rows where peek(counter)&lt;counter but the last column is what qlik does instead.</P><P></P><P>This load is reading a resident table.&nbsp; not sure if that makes a difference\</P><P></P><P>Thanks</P></BODY></HTML> Fri, 06 Jan 2017 21:58:01 GMT markp201 2017-01-06T21:58:01Z Peek or previous... https://community.qlik.com/t5/QlikView/Peek-or-previous/m-p/1287986#M403135 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="200" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 1px solid rgb(0, 0, 0); width: 226px; height: 180px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">rownum</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Counter</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Need<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Qlik does this</STRONG></TH></TR><TR><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>2</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>3</TD><TD>2</TD><TD>0</TD><TD>1</TD></TR><TR><TD>4</TD><TD>3</TD><TD>1</TD><TD>1</TD></TR><TR><TD>5</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>6</TD><TD>2</TD><TD>1</TD><TD>1</TD></TR><TR><TD>7</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P></P><P>I want to flag the rows where peek(counter)&lt;counter but the last column is what qlik does instead.</P><P></P><P>This load is reading a resident table.&nbsp; not sure if that makes a difference\</P><P></P><P>Thanks</P></BODY></HTML> Fri, 06 Jan 2017 21:58:01 GMT https://community.qlik.com/t5/QlikView/Peek-or-previous/m-p/1287986#M403135 markp201 2017-01-06T21:58:01Z Re: Peek or previous... https://community.qlik.com/t5/QlikView/Peek-or-previous/m-p/1287987#M403136 <HTML><HEAD></HEAD><BODY><P>This returns your desired results:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_1483742235211220 jive_text_macro" jivemacro_uid="_1483742235211220"> <P>Data:</P> <P>LOAD * INLINE [</P> <P>&nbsp;&nbsp;&nbsp; rownum, Counter</P> <P>&nbsp;&nbsp;&nbsp; 1, 0</P> <P>&nbsp;&nbsp;&nbsp; 2, 1</P> <P>&nbsp;&nbsp;&nbsp; 3, 2</P> <P>&nbsp;&nbsp;&nbsp; 4, 3</P> <P>&nbsp;&nbsp;&nbsp; 5, 1</P> <P>&nbsp;&nbsp;&nbsp; 6, 2</P> <P>&nbsp;&nbsp;&nbsp; 7, 0</P> <P>];</P> <P></P> <P>Test:</P> <P>LOAD rownum, Counter, IF(PEEK(Counter) &lt; Counter, 1, 0) as peek</P> <P>RESIDENT Data</P> <P>ORDER BY rownum DESC, Counter DESC;</P> <P></P> <P>DROP TABLE Data;</P> </PRE><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>rownum</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Counter</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>peek</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">6</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">7</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR></TBODY></TABLE><P></P><P>I've also attached an example file.</P></BODY></HTML> Fri, 06 Jan 2017 22:37:46 GMT https://community.qlik.com/t5/QlikView/Peek-or-previous/m-p/1287987#M403136 Nicole-Smith 2017-01-06T22:37:46Z