topic Re: Expression for dynamic label in QlikView https://community.qlik.com/t5/QlikView/Expression-for-dynamic-label/m-p/1194881#M882460 <HTML><HEAD></HEAD><BODY><P>Was able to get this to work, thank you!</P></BODY></HTML> Fri, 30 Sep 2016 13:46:20 GMT 2016-09-30T13:46:20Z Expression for dynamic label https://community.qlik.com/t5/QlikView/Expression-for-dynamic-label/m-p/1194878#M882457 <HTML><HEAD></HEAD><BODY><P>I have a field in my dates table called WeekNo, which is used as the basis for summing my data.&nbsp; Also in my dates table I have a field called Rpt Wk.&nbsp; Within this dates table, WeekNo = 260 corresponds to Rpt Wk = Sep Wk 5.&nbsp; How am I able to write a dynamic label expression that uses the max WeekNo but returns the Rpt Wk field value?&nbsp; Thank you in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-for-dynamic-label/m-p/1194878#M882457 2020-11-25T16:16:04Z Re: Expression for dynamic label https://community.qlik.com/t5/QlikView/Expression-for-dynamic-label/m-p/1194879#M882458 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>FirstSortedValue([Rpt Wk], -WeekNo)</STRONG></P></BODY></HTML> Thu, 29 Sep 2016 18:52:58 GMT https://community.qlik.com/t5/QlikView/Expression-for-dynamic-label/m-p/1194879#M882458 sunny_talwar 2016-09-29T18:52:58Z Re: Expression for dynamic label https://community.qlik.com/t5/QlikView/Expression-for-dynamic-label/m-p/1194880#M882459 <HTML><HEAD></HEAD><BODY><P>Hi Brian,</P><P>=MaxString({&lt;WeekNo = {$(=Max(WeekNo))}&gt;}[Rpt Wk])</P><P></P><P>Regards!</P></BODY></HTML> Fri, 30 Sep 2016 06:48:22 GMT https://community.qlik.com/t5/QlikView/Expression-for-dynamic-label/m-p/1194880#M882459 Anonymous 2016-09-30T06:48:22Z Re: Expression for dynamic label https://community.qlik.com/t5/QlikView/Expression-for-dynamic-label/m-p/1194881#M882460 <HTML><HEAD></HEAD><BODY><P>Was able to get this to work, thank you!</P></BODY></HTML> Fri, 30 Sep 2016 13:46:20 GMT https://community.qlik.com/t5/QlikView/Expression-for-dynamic-label/m-p/1194881#M882460 2016-09-30T13:46:20Z