topic How find MAX date with were? in QlikView https://community.qlik.com/t5/QlikView/How-find-MAX-date-with-were/m-p/1380048#M608596 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I have Table like this:</P><P>ItemId&nbsp;&nbsp;&nbsp;&nbsp; OperationDate&nbsp;&nbsp;&nbsp;&nbsp; Qty&nbsp;&nbsp;&nbsp;&nbsp; StatusReceipt&nbsp;&nbsp;&nbsp;&nbsp; StatusIssue</P><P>XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03/03/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Purch&nbsp;&nbsp;&nbsp;&nbsp; </P><P>XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/03/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&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;&nbsp;&nbsp;&nbsp;&nbsp; Sale</P><P>XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06/03/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ordered</P><P></P><P>How I can find ItemId firs date of Purch and Last date of Sale in Expression?</P></BODY></HTML> Mon, 11 Dec 2017 14:43:15 GMT irmantas 2017-12-11T14:43:15Z How find MAX date with were? https://community.qlik.com/t5/QlikView/How-find-MAX-date-with-were/m-p/1380048#M608596 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I have Table like this:</P><P>ItemId&nbsp;&nbsp;&nbsp;&nbsp; OperationDate&nbsp;&nbsp;&nbsp;&nbsp; Qty&nbsp;&nbsp;&nbsp;&nbsp; StatusReceipt&nbsp;&nbsp;&nbsp;&nbsp; StatusIssue</P><P>XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03/03/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Purch&nbsp;&nbsp;&nbsp;&nbsp; </P><P>XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/03/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&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;&nbsp;&nbsp;&nbsp;&nbsp; Sale</P><P>XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06/03/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ordered</P><P></P><P>How I can find ItemId firs date of Purch and Last date of Sale in Expression?</P></BODY></HTML> Mon, 11 Dec 2017 14:43:15 GMT https://community.qlik.com/t5/QlikView/How-find-MAX-date-with-were/m-p/1380048#M608596 irmantas 2017-12-11T14:43:15Z Re: How find MAX date with were? https://community.qlik.com/t5/QlikView/How-find-MAX-date-with-were/m-p/1380049#M608597 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>Dimension</P><P><STRONG>ItemId</STRONG></P><P></P><P>First date of Purch</P><P><STRONG>Min({&lt;StatusReceipt = {'Purch'}&gt;}OperationDate)</STRONG></P><P>Last date of Sale</P><P><STRONG>Max({&lt;StatusIssue = {'Sale'}&gt;}OperationDate)</STRONG></P></BODY></HTML> Mon, 11 Dec 2017 14:45:21 GMT https://community.qlik.com/t5/QlikView/How-find-MAX-date-with-were/m-p/1380049#M608597 sunny_talwar 2017-12-11T14:45:21Z Re: How find MAX date with were? https://community.qlik.com/t5/QlikView/How-find-MAX-date-with-were/m-p/1380050#M608598 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny. it's works.</P></BODY></HTML> Tue, 12 Dec 2017 06:18:45 GMT https://community.qlik.com/t5/QlikView/How-find-MAX-date-with-were/m-p/1380050#M608598 irmantas 2017-12-12T06:18:45Z