topic Re: Peek function - field not found... in QlikView https://community.qlik.com/t5/QlikView/Peek-function-field-not-found/m-p/1280133#M401529 <HTML><HEAD></HEAD><BODY><P>Oh merde - it was typo.&nbsp; Yes, it works now.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Thu, 05 Jan 2017 17:12:51 GMT markp201 2017-01-05T17:12:51Z Peek function - field not found... https://community.qlik.com/t5/QlikView/Peek-function-field-not-found/m-p/1280131#M401527 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="75" style="border: 1px solid rgb(0, 0, 0); width: 312px; height: 64px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">customer</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>salesman</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>match</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>what is needed</STRONG></P><P><STRONG>(run_sum)<BR /></STRONG></P></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">S1</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD>A</TD><TD>S1</TD><TD>1</TD><TD>2</TD></TR><TR><TD>A</TD><TD>S2</TD><TD>0</TD><TD>0</TD></TR><TR><TD>A</TD><TD>S3</TD><TD>1</TD><TD>1</TD></TR><TR><TD>A</TD><TD>S3</TD><TD>1</TD><TD>2</TD></TR><TR><TD>B</TD><TD>S1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>B</TD><TD>S4</TD><TD>1</TD><TD>1</TD></TR><TR><TD>B</TD><TD>S4</TD><TD>1</TD><TD>2</TD></TR><TR><TD>B</TD><TD>S3</TD><TD>1</TD><TD>1</TD></TR><TR><TD>B</TD><TD>S3</TD><TD>1</TD><TD>2</TD></TR></TBODY></TABLE><P></P><P>if(Previous(customer&amp;salesman)=customer&amp;salesname,rangesum(peek(run_sum,-1),match),match) as run_sum</P><P>We're getting field not found &lt;match&gt;</P><P></P><P>This is a resident load from a table with customer,salesman, match</P></BODY></HTML> Thu, 05 Jan 2017 16:55:48 GMT https://community.qlik.com/t5/QlikView/Peek-function-field-not-found/m-p/1280131#M401527 markp201 2017-01-05T16:55:48Z Re: Peek function - field not found... https://community.qlik.com/t5/QlikView/Peek-function-field-not-found/m-p/1280132#M401528 <HTML><HEAD></HEAD><BODY><P>Seems to be working</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD * INLINE [</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; customer, salesman, match, </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; A, S1, 1</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; A, S1, 1</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; A, S2, 0</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; A, S3, 1</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; A, S3, 1</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; B, S1, 0</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; B, S4, 1</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; B, S4, 1</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; B, S3, 1</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; B, S3, 1</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><STRONG>FinalTable:</STRONG></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG>&nbsp; if(Previous(customer&amp;salesman)=customer&amp;salesman,rangesum(peek(run_sum,-1),match),match) as run_sum</STRONG></P><P><STRONG>Resident Table</STRONG></P><P><STRONG>Order By customer, salesman;</STRONG></P><P></P><P><STRONG>DROP Table Table;</STRONG></P></BODY></HTML> Thu, 05 Jan 2017 17:00:50 GMT https://community.qlik.com/t5/QlikView/Peek-function-field-not-found/m-p/1280132#M401528 sunny_talwar 2017-01-05T17:00:50Z Re: Peek function - field not found... https://community.qlik.com/t5/QlikView/Peek-function-field-not-found/m-p/1280133#M401529 <HTML><HEAD></HEAD><BODY><P>Oh merde - it was typo.&nbsp; Yes, it works now.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Thu, 05 Jan 2017 17:12:51 GMT https://community.qlik.com/t5/QlikView/Peek-function-field-not-found/m-p/1280133#M401529 markp201 2017-01-05T17:12:51Z