topic peek question in QlikView https://community.qlik.com/t5/QlikView/peek-question/m-p/178382#M45596 <HTML><HEAD></HEAD><BODY><P>You need to get a sorting into it and check for your condition. Script may look like</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">NetDateTime,<BR />IF(User = PEEK(User), PEEK(NetDateTime)) AS Peek,<BR />User<BR />FROM ...<BR />ORDER BY<BR />User ASC,<BR />NetDateTime DESC;</PRE></BLOCKQUOTE><BR /><BR /> <P>HTH<BR />Peter</P></BODY></HTML> Tue, 08 Dec 2009 04:44:07 GMT prieper 2009-12-08T04:44:07Z peek question https://community.qlik.com/t5/QlikView/peek-question/m-p/178381#M45595 <HTML><HEAD></HEAD><BODY><P>NetDateTime,<BR />Peek('NetDateTime') As Peek,<BR />User<BR /><BR />FROM....</P><P></P><P>Peek gives me here the 'highest' datetime that is found .. regardless of the user.</P><P>What i want is the Peek of NetDateTime where the user is equel to the user of the current record that is loaded</P><P>Thanks in advanced</P></BODY></HTML> Tue, 08 Dec 2009 04:11:34 GMT https://community.qlik.com/t5/QlikView/peek-question/m-p/178381#M45595 amien 2009-12-08T04:11:34Z peek question https://community.qlik.com/t5/QlikView/peek-question/m-p/178382#M45596 <HTML><HEAD></HEAD><BODY><P>You need to get a sorting into it and check for your condition. Script may look like</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">NetDateTime,<BR />IF(User = PEEK(User), PEEK(NetDateTime)) AS Peek,<BR />User<BR />FROM ...<BR />ORDER BY<BR />User ASC,<BR />NetDateTime DESC;</PRE></BLOCKQUOTE><BR /><BR /> <P>HTH<BR />Peter</P></BODY></HTML> Tue, 08 Dec 2009 04:44:07 GMT https://community.qlik.com/t5/QlikView/peek-question/m-p/178382#M45596 prieper 2009-12-08T04:44:07Z