topic Re: Getting Particular dates using firstsortedvalue in QlikView https://community.qlik.com/t5/QlikView/Getting-Particular-dates-using-firstsortedvalue/m-p/1285262#M869527 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Tue, 06 Dec 2016 05:46:19 GMT tresB 2016-12-06T05:46:19Z Getting Particular dates using firstsortedvalue https://community.qlik.com/t5/QlikView/Getting-Particular-dates-using-firstsortedvalue/m-p/1285261#M869526 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Consider 3 fields from a table.</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><THEAD style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TH class="header headerSortDown" style="border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; color: #ffffff; background-color: #6690bc;" valign="middle">Name</TH><TH class="header" style="border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; color: #ffffff; background-color: #6690bc;" valign="middle">Date</TH><TH class="header" style="border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; color: #ffffff; background-color: #6690bc;" valign="middle">Profit</TH></TR></THEAD><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">11/26/2016</TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">100</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/21/2016</SPAN></TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">200</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016</SPAN></TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">230</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">b</TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/26/2016</SPAN></TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">454</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">b</TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016</SPAN></TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">690</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">b</TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/12/2016</SPAN></TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">500</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">c</TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/21/2016</SPAN></TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">123</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">c</TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016</SPAN></TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">333</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">c</TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/12/2016</SPAN></TD><TD style="border: 1px solid #000000; font-style: inherit; font-family: inherit;">140</TD></TR></TBODY></TABLE><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">from this table, i need to get the Names which are on saturday's (26,19,12).</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Like below, can we achieve this using firstsortedvalue function.? or with something else?</P><P></P><P style="font-weight: inherit; font-style: inherit;">What i want is like below, It should pick only saturday on max Date and Previous Date and those corresponding values.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; font-weight: inherit; font-style: inherit;"><THEAD style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TH class="headerSortDown header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; background-color: #6690bc; color: #ffffff;" valign="middle">Name</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; background-color: #6690bc; color: #ffffff;" valign="middle">max Date</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; background-color: #6690bc; color: #ffffff;" valign="middle">Profit</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; background-color: #6690bc; color: #ffffff;" valign="middle">Previous Date</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; background-color: #6690bc; color: #ffffff;" valign="middle">Profit</TH></TR></THEAD><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">11/26/2016</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit;">100</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">230</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">b</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/26/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit;">454</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; font-weight: inherit; font-style: inherit; font-family: inherit;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016<BR /><BR /></SPAN></TD></TR></TBODY></TABLE></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">690</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">c</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">333</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/12/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">140</TD></TR></TBODY></TABLE><P class="jive-thread-reply-btn" style="margin: 15px 0 -10px; font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><DIV class="jive-thread-reply-btn-correct" style="font-weight: inherit; font-style: inherit; font-size: 11.7px; font-family: inherit;"><A _jive_internal="true" href="https://community.qlik.com/message/1172144" style="margin: 0 20px 0 0; padding: 2px 14px 4px 28px; font-weight: bold; font-style: inherit; font-size: 11.7px; font-family: inherit; color: #3778c7; background-color: #f3f3f3;" target="_blank">Getting Particular dates using firstsortedvalue</A><P></P></DIV><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks..</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Getting-Particular-dates-using-firstsortedvalue/m-p/1285261#M869526 Anonymous 2020-11-25T16:16:04Z Re: Getting Particular dates using firstsortedvalue https://community.qlik.com/t5/QlikView/Getting-Particular-dates-using-firstsortedvalue/m-p/1285262#M869527 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Tue, 06 Dec 2016 05:46:19 GMT https://community.qlik.com/t5/QlikView/Getting-Particular-dates-using-firstsortedvalue/m-p/1285262#M869527 tresB 2016-12-06T05:46:19Z Re: Getting Particular dates using firstsortedvalue https://community.qlik.com/t5/QlikView/Getting-Particular-dates-using-firstsortedvalue/m-p/1285263#M869528 <HTML><HEAD></HEAD><BODY><P>You may use this for calculated Dim and use Name</P><P></P><P><STRONG>If(WeekDay(Date) = 'Sat', Date)</STRONG></P><P></P><P>Then Expresssion could be <STRONG>Sum(Profit)</STRONG></P></BODY></HTML> Tue, 06 Dec 2016 06:10:46 GMT https://community.qlik.com/t5/QlikView/Getting-Particular-dates-using-firstsortedvalue/m-p/1285263#M869528 Anil_Babu_Samineni 2016-12-06T06:10:46Z Re: Getting Particular dates using firstsortedvalue https://community.qlik.com/t5/QlikView/Getting-Particular-dates-using-firstsortedvalue/m-p/1285264#M869529 <HTML><HEAD></HEAD><BODY><P>Hi Kishore,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This might help you :</P><P>&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">FirstSortedValue</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Profit</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">WeekDay</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sort_Date</SPAN><SPAN style="font-size: 8pt;">)='Sat',</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sort_Date</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P><SPAN style="font-size: 8pt;"><BR /></SPAN></P><P><SPAN style="font-size: 8pt;">Regards,</SPAN></P><P><SPAN style="font-size: 8pt;">Nitin</SPAN></P></BODY></HTML> Tue, 06 Dec 2016 07:35:59 GMT https://community.qlik.com/t5/QlikView/Getting-Particular-dates-using-firstsortedvalue/m-p/1285264#M869529 nitin_01 2016-12-06T07:35:59Z Re: Getting Particular dates using firstsortedvalue https://community.qlik.com/t5/QlikView/Getting-Particular-dates-using-firstsortedvalue/m-p/1285265#M869530 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi ill change my requirement.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><THEAD style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TH class="headerSortDown header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; background-color: #6690bc; color: #ffffff;" valign="middle">Name</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; background-color: #6690bc; color: #ffffff;" valign="middle">Date</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; background-color: #6690bc; color: #ffffff;" valign="middle">Profit</TH></TR></THEAD><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">11/26/2016</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">100</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/21/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">200</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">230</TD></TR><TR><TD>a</TD><TD>11/14/2016</TD><TD>150</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">b</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/26/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">454</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">b</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">690</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">b</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/12/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">500</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">c</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/21/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">123</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">c</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">333</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">c</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/12/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">140</TD></TR></TBODY></TABLE><P></P><P>What i want is like below, It should pick only saturday on max Date and Previous Date and those corresponding values.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><THEAD style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TH class="headerSortDown header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; background-color: #6690bc; color: #ffffff;" valign="middle">Name</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; background-color: #6690bc; color: #ffffff;" valign="middle"> max Date</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; background-color: #6690bc; color: #ffffff;" valign="middle">Profit</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; background-color: #6690bc; color: #ffffff;" valign="middle">Previous Date</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; background-color: #6690bc; color: #ffffff;" valign="middle">Profit</TH></TR></THEAD><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">11/26/2016</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">100</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">11/19/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">230</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">b</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/26/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">454</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="border: 1px solid #000000; padding-right: 4px; padding-left: 4px; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016<BR /><BR /></SPAN></TD></TR></TBODY></TABLE></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">690</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">c</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">333</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">11/12/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">140</TD></TR></TBODY></TABLE><P></P><P>Can you please help me.</P></BODY></HTML> Tue, 06 Dec 2016 09:29:11 GMT https://community.qlik.com/t5/QlikView/Getting-Particular-dates-using-firstsortedvalue/m-p/1285265#M869530 Anonymous 2016-12-06T09:29:11Z Re: Getting Particular dates using firstsortedvalue https://community.qlik.com/t5/QlikView/Getting-Particular-dates-using-firstsortedvalue/m-p/1285266#M869531 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi ill change my requirement.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><THEAD style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TH class="header headerSortDown" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; color: #ffffff; background-color: #6690bc;" valign="middle">Name</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; color: #ffffff; background-color: #6690bc;" valign="middle">Date</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; color: #ffffff; background-color: #6690bc;" valign="middle">Profit</TH></TR></THEAD><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">11/26/2016</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">100</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/21/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">200</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">230</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">11/14/2016</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">150</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">b</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/26/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">454</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">b</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">690</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">b</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/12/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">500</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">c</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/21/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">123</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">c</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">333</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">c</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/12/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">140</TD></TR></TBODY></TABLE><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">What i want is like below, It should pick only saturday on max Date and Previous Date and those corresponding values.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><THEAD style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TH class="header headerSortDown" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; color: #ffffff; background-color: #6690bc;" valign="middle">Name</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; color: #ffffff; background-color: #6690bc;" valign="middle">max Date</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; color: #ffffff; background-color: #6690bc;" valign="middle">Profit</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; color: #ffffff; background-color: #6690bc;" valign="middle">Previous Date</TH><TH class="header" style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit; text-align: center; background-position: no-repeat; color: #ffffff; background-color: #6690bc;" valign="middle">Profit</TH></TR></THEAD><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">a</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">11/26/2016</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit;">100</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px;">11/19/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">230</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">b</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/26/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit;">454</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; font-weight: inherit; font-style: inherit;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016<BR /><BR /></SPAN></TD></TR></TBODY></TABLE></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">690</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">c</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">11/19/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">333</TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px;">11/12/2016</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 1px solid #000000; font-style: inherit; font-family: inherit;">140</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 06 Dec 2016 09:29:50 GMT https://community.qlik.com/t5/QlikView/Getting-Particular-dates-using-firstsortedvalue/m-p/1285266#M869531 Anonymous 2016-12-06T09:29:50Z