topic Re: Variable in expression..... in QlikView https://community.qlik.com/t5/QlikView/Variable-in-expression/m-p/820697#M1018202 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Try to use some function for [KPI_Details] field. For instance</P><P></P><P><SPAN style="color: #808080;"><STRONG><EM>$(='v'&amp; MinString(</EM></STRONG>[KPI_Details<STRONG><EM>) &amp; '_RAG')</EM></STRONG></SPAN></P><P><SPAN style="color: #808080;"><STRONG></STRONG></SPAN></P><P><SPAN style="color: #808080;">or any other suitable</SPAN></P></BODY></HTML> Tue, 31 Mar 2015 13:23:03 GMT yura_ratu 2015-03-31T13:23:03Z Variable in expression..... https://community.qlik.com/t5/QlikView/Variable-in-expression/m-p/820696#M1018201 <HTML><HEAD></HEAD><BODY><P>The following works in a text box</P><P></P><P>=</P><P></P><P><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(='v'&amp;'KPI_01_01_RAG') </EM></STRONG></P><P><STRONG></STRONG> </P><P><STRONG></STRONG> </P><P><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG></STRONG></EM></STRONG><EM style="color: #808080; font-size: 8pt;"></EM></P><P></P><P>And the following works within a chart</P><P></P><P>='v'&amp;</P><P></P><P><SPAN style="color: #800000; font-size: 8pt;">[KPI_Details] </SPAN><SPAN style="font-size: 8pt;"> &amp; '_RAG' </SPAN></P><P></P><P>But they do not work together in a chart:</P><P></P><P>=</P><P></P><P><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(='v'&amp; '[KPI_Details]' &amp; '_RAG')</EM></STRONG></EM></STRONG><EM style="color: #808080; font-size: 8pt;"></EM></P><P><SPAN style="font-size: 8pt;"><BR /></SPAN></P><P>What am I missing?</P></BODY></HTML> Mon, 30 Mar 2015 14:53:49 GMT https://community.qlik.com/t5/QlikView/Variable-in-expression/m-p/820696#M1018201 2015-03-30T14:53:49Z Re: Variable in expression..... https://community.qlik.com/t5/QlikView/Variable-in-expression/m-p/820697#M1018202 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Try to use some function for [KPI_Details] field. For instance</P><P></P><P><SPAN style="color: #808080;"><STRONG><EM>$(='v'&amp; MinString(</EM></STRONG>[KPI_Details<STRONG><EM>) &amp; '_RAG')</EM></STRONG></SPAN></P><P><SPAN style="color: #808080;"><STRONG></STRONG></SPAN></P><P><SPAN style="color: #808080;">or any other suitable</SPAN></P></BODY></HTML> Tue, 31 Mar 2015 13:23:03 GMT https://community.qlik.com/t5/QlikView/Variable-in-expression/m-p/820697#M1018202 yura_ratu 2015-03-31T13:23:03Z Re: Variable in expression..... https://community.qlik.com/t5/QlikView/Variable-in-expression/m-p/820698#M1018203 <HTML><HEAD></HEAD><BODY><P>This issue seems to have been already resolved, isn't it?</P><P></P><P><A href="https://community.qlik.com/thread/158141">Caculated variable not showing in chart...</A></P></BODY></HTML> Tue, 31 Mar 2015 13:26:32 GMT https://community.qlik.com/t5/QlikView/Variable-in-expression/m-p/820698#M1018203 sunny_talwar 2015-03-31T13:26:32Z Re: Variable in expression..... https://community.qlik.com/t5/QlikView/Variable-in-expression/m-p/820699#M1018204 <HTML><HEAD></HEAD><BODY><P>Correct - I was just looking to figure out how to delete a duplicate post....</P></BODY></HTML> Tue, 31 Mar 2015 13:28:11 GMT https://community.qlik.com/t5/QlikView/Variable-in-expression/m-p/820699#M1018204 2015-03-31T13:28:11Z Re: Variable in expression..... https://community.qlik.com/t5/QlikView/Variable-in-expression/m-p/820700#M1018205 <HTML><HEAD></HEAD><BODY><P>Delete it or you can do an assumed answer to close this thread <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 31 Mar 2015 13:29:31 GMT https://community.qlik.com/t5/QlikView/Variable-in-expression/m-p/820700#M1018205 sunny_talwar 2015-03-31T13:29:31Z