topic Capture Max date and Min date in QlikView https://community.qlik.com/t5/QlikView/Capture-Max-date-and-Min-date/m-p/787800#M278582 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #808080;">Hi ALL,</SPAN></P><P></P><P><SPAN style="color: #808080;">I have 2 fields i need to find a single record based on "<SPAN style="font-size: 10pt; line-height: 1.5em;">Oldest committed Forecast date (when Event Data is minimum) column and Latest committed Forecast date (when Event Data is maximum)". </SPAN></SPAN><SPAN style="color: #808080; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 1.5em;">For each project for the current phase ID.</SPAN></P><P></P><P></P><P><IMG __jive_id="75262" class="image-1 jive-image" height="100" src="https://community.qlik.com/legacyfs/online/75262_pastedImage_3.png" style="width: 815.789473684211px; height: 100px;" width="816" /></P><P></P><P>Thankyou All</P><P>Vamsi</P></BODY></HTML> Wed, 14 Jan 2015 09:21:19 GMT 2015-01-14T09:21:19Z Capture Max date and Min date https://community.qlik.com/t5/QlikView/Capture-Max-date-and-Min-date/m-p/787800#M278582 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #808080;">Hi ALL,</SPAN></P><P></P><P><SPAN style="color: #808080;">I have 2 fields i need to find a single record based on "<SPAN style="font-size: 10pt; line-height: 1.5em;">Oldest committed Forecast date (when Event Data is minimum) column and Latest committed Forecast date (when Event Data is maximum)". </SPAN></SPAN><SPAN style="color: #808080; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 1.5em;">For each project for the current phase ID.</SPAN></P><P></P><P></P><P><IMG __jive_id="75262" class="image-1 jive-image" height="100" src="https://community.qlik.com/legacyfs/online/75262_pastedImage_3.png" style="width: 815.789473684211px; height: 100px;" width="816" /></P><P></P><P>Thankyou All</P><P>Vamsi</P></BODY></HTML> Wed, 14 Jan 2015 09:21:19 GMT https://community.qlik.com/t5/QlikView/Capture-Max-date-and-Min-date/m-p/787800#M278582 2015-01-14T09:21:19Z Re: Capture Max date and Min date https://community.qlik.com/t5/QlikView/Capture-Max-date-and-Min-date/m-p/787801#M278583 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You need to look at first sorted value function</P><P></P><P></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 14 Jan 2015 09:35:55 GMT https://community.qlik.com/t5/QlikView/Capture-Max-date-and-Min-date/m-p/787801#M278583 ashfaq_haseeb 2015-01-14T09:35:55Z Re: Capture Max date and Min date https://community.qlik.com/t5/QlikView/Capture-Max-date-and-Min-date/m-p/787802#M278584 <HTML><HEAD></HEAD><BODY><P>Thankyou Ashfaq</P></BODY></HTML> Wed, 14 Jan 2015 11:51:14 GMT https://community.qlik.com/t5/QlikView/Capture-Max-date-and-Min-date/m-p/787802#M278584 2015-01-14T11:51:14Z