topic Re: $ sign expansion not working in QlikView https://community.qlik.com/t5/QlikView/sign-expansion-not-working/m-p/60739#M10103 <HTML><HEAD></HEAD><BODY><P>How about this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Min({&lt;[Cust_Balance]={"$(=Min(Cust_Balance))"}&gt;} [Cust_date])</STRONG></SPAN></P><P></P><P>or this</P><P><STRONG>FirstSortedValue(Cust_date, Cust_Balance)</STRONG></P></BODY></HTML> Tue, 05 Jun 2018 18:06:08 GMT sunny_talwar 2018-06-05T18:06:08Z $ sign expansion not working https://community.qlik.com/t5/QlikView/sign-expansion-not-working/m-p/60738#M10102 <HTML><HEAD></HEAD><BODY><P>I have a table of account balances and dates for each.&nbsp; I can find the minimum and maximum balance easily, but I also want to show when that minimum or maximum was reached.&nbsp; I have tried several variations on this expression to no avail.&nbsp; Can some one please let me know what is missing in my set expression?&nbsp; The expression editor says that this expression is OK, but it returns no results.</P><P></P><P>=Min({&lt;[Cust_Balance]={$(=Min(Cust_Balance))}&gt;} [Cust_date])</P></BODY></HTML> Tue, 05 Jun 2018 17:55:30 GMT https://community.qlik.com/t5/QlikView/sign-expansion-not-working/m-p/60738#M10102 dwfiv327 2018-06-05T17:55:30Z Re: $ sign expansion not working https://community.qlik.com/t5/QlikView/sign-expansion-not-working/m-p/60739#M10103 <HTML><HEAD></HEAD><BODY><P>How about this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Min({&lt;[Cust_Balance]={"$(=Min(Cust_Balance))"}&gt;} [Cust_date])</STRONG></SPAN></P><P></P><P>or this</P><P><STRONG>FirstSortedValue(Cust_date, Cust_Balance)</STRONG></P></BODY></HTML> Tue, 05 Jun 2018 18:06:08 GMT https://community.qlik.com/t5/QlikView/sign-expansion-not-working/m-p/60739#M10103 sunny_talwar 2018-06-05T18:06:08Z Re: $ sign expansion not working https://community.qlik.com/t5/QlikView/sign-expansion-not-working/m-p/60740#M10104 <HTML><HEAD></HEAD><BODY><P>The first expression is no better than the one I was using. However, the <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FirstSortedValue <SPAN style="font-size: 13.3333px;">works!&nbsp; Thanks. </SPAN></STRONG></P></BODY></HTML> Tue, 05 Jun 2018 18:11:07 GMT https://community.qlik.com/t5/QlikView/sign-expansion-not-working/m-p/60740#M10104 dwfiv327 2018-06-05T18:11:07Z