topic Re: expression problem in QlikView https://community.qlik.com/t5/QlikView/expression-problem/m-p/624751#M1109367 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>use this expression</P><P>MaxString(Aggr(description,date))</P></BODY></HTML> Tue, 11 Mar 2014 14:27:37 GMT PrashantSangle 2014-03-11T14:27:37Z expression problem https://community.qlik.com/t5/QlikView/expression-problem/m-p/624745#M1109361 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>callid</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>description</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1.1.14</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2.1.14</TD><TD style="padding: 2px;">b</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">5.1.14</TD><TD style="padding: 2px;">c</TD></TR></TBODY></TABLE><P></P><P>i want to get this table</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>callid</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>last des</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">c</TD></TR></TBODY></TABLE><P></P><P>i want to get the latest description (by date).</P><P></P><P>what should i put in the last des expression?<STRONG style="color: #ffffff; text-align: center;">es</STRONG></P></BODY></HTML> Tue, 11 Mar 2014 14:03:36 GMT https://community.qlik.com/t5/QlikView/expression-problem/m-p/624745#M1109361 adiarnon 2014-03-11T14:03:36Z Re: expression problem https://community.qlik.com/t5/QlikView/expression-problem/m-p/624746#M1109362 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>max(aggr(description, date)</P><P></P><P>beware date has to be under date format</P><P></P><P>best regards</P><P>chris</P></BODY></HTML> Tue, 11 Mar 2014 14:07:44 GMT https://community.qlik.com/t5/QlikView/expression-problem/m-p/624746#M1109362 2014-03-11T14:07:44Z Re: expression problem https://community.qlik.com/t5/QlikView/expression-problem/m-p/624747#M1109363 <HTML><HEAD></HEAD><BODY><P>You can use the expression</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">MaxString</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">description</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><BR /> </P></BODY></HTML> Tue, 11 Mar 2014 14:10:34 GMT https://community.qlik.com/t5/QlikView/expression-problem/m-p/624747#M1109363 2014-03-11T14:10:34Z Re: expression problem https://community.qlik.com/t5/QlikView/expression-problem/m-p/624748#M1109364 <HTML><HEAD></HEAD><BODY><P>Should be able to use firstsortedvalue(). Something like:</P><P></P><P>firstsortedvalue(description, -date)</P><P></P><P>Hope this helps!</P></BODY></HTML> Tue, 11 Mar 2014 14:18:03 GMT https://community.qlik.com/t5/QlikView/expression-problem/m-p/624748#M1109364 jerem1234 2014-03-11T14:18:03Z Re: expression problem https://community.qlik.com/t5/QlikView/expression-problem/m-p/624749#M1109365 <HTML><HEAD></HEAD><BODY><P>Adi Arnon,</P><P></P><P>Just load your data, make sure your date column is loading according to your system format.</P><P></P><P>In st. table: Dim as Callid and Exp as =FirstSortedValue(description,-date)</P><P></P><P>Thanks,</P><P>Jagan</P></BODY></HTML> Tue, 11 Mar 2014 14:20:24 GMT https://community.qlik.com/t5/QlikView/expression-problem/m-p/624749#M1109365 jagannalla 2014-03-11T14:20:24Z Re: expression problem https://community.qlik.com/t5/QlikView/expression-problem/m-p/624750#M1109366 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>its not working =\</P><P></P><P>what do you mean by date format? </P></BODY></HTML> Tue, 11 Mar 2014 14:20:50 GMT https://community.qlik.com/t5/QlikView/expression-problem/m-p/624750#M1109366 adiarnon 2014-03-11T14:20:50Z Re: expression problem https://community.qlik.com/t5/QlikView/expression-problem/m-p/624751#M1109367 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>use this expression</P><P>MaxString(Aggr(description,date))</P></BODY></HTML> Tue, 11 Mar 2014 14:27:37 GMT https://community.qlik.com/t5/QlikView/expression-problem/m-p/624751#M1109367 PrashantSangle 2014-03-11T14:27:37Z