topic expression problem in QlikView https://community.qlik.com/t5/QlikView/expression-problem/m-p/1234734#M392948 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">hi i have an expression-</SPAN></P><P><SPAN style="font-size: 12pt;">='v_for_'&amp;<SPAN style="color: #0000ff;">MaxString</SPAN>({&lt;<SPAN style="color: #800000;">Metric_display_no</SPAN>={1}&gt;}<SPAN style="color: #800000;">Metric_ID</SPAN>) </SPAN></P><P><SPAN style="font-size: 12pt;">the result is - v_for_24_4</SPAN></P><P><SPAN style="font-size: 12pt;">v_for_24_4 is a variable </SPAN></P><P><SPAN style="font-size: 12pt;">$(v_for_24_4) = 1.29</SPAN></P><P><SPAN style="font-size: 12pt;"><BR /></SPAN></P><P><SPAN style="font-size: 12pt;">i need a text box with somthing like</SPAN></P><P><SPAN style="font-size: 12pt;">=<SPAN style="color: #339966;">$(</SPAN>&nbsp;&nbsp; 'v_for_'&amp;<SPAN style="color: #0000ff;">MaxString</SPAN>({&lt;<SPAN style="color: #800000;">Metric_display_no</SPAN>={1}&gt;}<SPAN style="color: #800000;">Metric_ID</SPAN>)&nbsp;&nbsp; <SPAN style="color: #008000;">)</SPAN></SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 12pt;">that will give me the result = 1.29</SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 12pt;">what syntax shoul i use?</SPAN></P><P></P></BODY></HTML> Mon, 06 Mar 2017 09:45:26 GMT adiarnon 2017-03-06T09:45:26Z expression problem https://community.qlik.com/t5/QlikView/expression-problem/m-p/1234734#M392948 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">hi i have an expression-</SPAN></P><P><SPAN style="font-size: 12pt;">='v_for_'&amp;<SPAN style="color: #0000ff;">MaxString</SPAN>({&lt;<SPAN style="color: #800000;">Metric_display_no</SPAN>={1}&gt;}<SPAN style="color: #800000;">Metric_ID</SPAN>) </SPAN></P><P><SPAN style="font-size: 12pt;">the result is - v_for_24_4</SPAN></P><P><SPAN style="font-size: 12pt;">v_for_24_4 is a variable </SPAN></P><P><SPAN style="font-size: 12pt;">$(v_for_24_4) = 1.29</SPAN></P><P><SPAN style="font-size: 12pt;"><BR /></SPAN></P><P><SPAN style="font-size: 12pt;">i need a text box with somthing like</SPAN></P><P><SPAN style="font-size: 12pt;">=<SPAN style="color: #339966;">$(</SPAN>&nbsp;&nbsp; 'v_for_'&amp;<SPAN style="color: #0000ff;">MaxString</SPAN>({&lt;<SPAN style="color: #800000;">Metric_display_no</SPAN>={1}&gt;}<SPAN style="color: #800000;">Metric_ID</SPAN>)&nbsp;&nbsp; <SPAN style="color: #008000;">)</SPAN></SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 12pt;">that will give me the result = 1.29</SPAN></P><P></P><P><SPAN style="color: #000000; font-size: 12pt;">what syntax shoul i use?</SPAN></P><P></P></BODY></HTML> Mon, 06 Mar 2017 09:45:26 GMT https://community.qlik.com/t5/QlikView/expression-problem/m-p/1234734#M392948 adiarnon 2017-03-06T09:45:26Z Re: expression problem https://community.qlik.com/t5/QlikView/expression-problem/m-p/1234735#M392949 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>=$( $(= 'v_for_'&amp;<SPAN style="color: #0000ff;">MaxString</SPAN>({&lt;<SPAN style="color: #800000;">Metric_display_no</SPAN>={1}&gt;}<SPAN style="color: #800000;">Metric_ID</SPAN>) ) )</P><P></P><P>or</P><P></P><P>= $(= 'v_for_'&amp;<SPAN style="color: #0000ff;">MaxString</SPAN>({&lt;<SPAN style="color: #800000;">Metric_display_no</SPAN>={1}&gt;}<SPAN style="color: #800000;">Metric_ID</SPAN>) )</P></BODY></HTML> Mon, 06 Mar 2017 09:54:03 GMT https://community.qlik.com/t5/QlikView/expression-problem/m-p/1234735#M392949 swuehl 2017-03-06T09:54:03Z Re: expression problem https://community.qlik.com/t5/QlikView/expression-problem/m-p/1234736#M392950 <HTML><HEAD></HEAD><BODY><P>#1 is working!!!</P><P>tnx</P></BODY></HTML> Mon, 06 Mar 2017 09:57:16 GMT https://community.qlik.com/t5/QlikView/expression-problem/m-p/1234736#M392950 adiarnon 2017-03-06T09:57:16Z