topic Include a string in a variable in QlikView https://community.qlik.com/t5/QlikView/Include-a-string-in-a-variable/m-p/329951#M1175790 <HTML><HEAD></HEAD><BODY><DIV> Hi. This is a simple problem, but I just cant get it to work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /> </DIV><DIV> </DIV><DIV>I have a variable <STRONG><EM>vDummy_Product</EM></STRONG> that returns <SPAN style="color: #ff0000;">'Cheque'</SPAN>, but when I try to include the variable in the following expression (highlighted in red), no luck. <SPAN style="font-size: 8pt;"><DIV> </DIV></SPAN></DIV><DIV><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff; font-size: 12pt;">sum</SPAN><SPAN style="font-size: 12pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 12pt;">PROD_GRP_DESC_Dummy</SPAN><SPAN style="font-size: 12pt;"> = <SPAN style="color: #333333;"><SPAN style="color: #ff0000;">{'Cheque'}</SPAN>&gt;}</SPAN></SPAN><SPAN style="color: #333333; font-size: 12pt;">Total_Rel_Rev</SPAN><SPAN style="font-size: 12pt;">) </SPAN></SPAN></DIV><DIV><SPAN style="font-size: 12pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV></BODY></HTML> Fri, 30 Mar 2012 12:28:27 GMT 2012-03-30T12:28:27Z Include a string in a variable https://community.qlik.com/t5/QlikView/Include-a-string-in-a-variable/m-p/329951#M1175790 <HTML><HEAD></HEAD><BODY><DIV> Hi. This is a simple problem, but I just cant get it to work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /> </DIV><DIV> </DIV><DIV>I have a variable <STRONG><EM>vDummy_Product</EM></STRONG> that returns <SPAN style="color: #ff0000;">'Cheque'</SPAN>, but when I try to include the variable in the following expression (highlighted in red), no luck. <SPAN style="font-size: 8pt;"><DIV> </DIV></SPAN></DIV><DIV><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff; font-size: 12pt;">sum</SPAN><SPAN style="font-size: 12pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 12pt;">PROD_GRP_DESC_Dummy</SPAN><SPAN style="font-size: 12pt;"> = <SPAN style="color: #333333;"><SPAN style="color: #ff0000;">{'Cheque'}</SPAN>&gt;}</SPAN></SPAN><SPAN style="color: #333333; font-size: 12pt;">Total_Rel_Rev</SPAN><SPAN style="font-size: 12pt;">) </SPAN></SPAN></DIV><DIV><SPAN style="font-size: 12pt;"> </SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV></BODY></HTML> Fri, 30 Mar 2012 12:28:27 GMT https://community.qlik.com/t5/QlikView/Include-a-string-in-a-variable/m-p/329951#M1175790 2012-03-30T12:28:27Z Include a string in a variable https://community.qlik.com/t5/QlikView/Include-a-string-in-a-variable/m-p/329952#M1175791 <HTML><HEAD></HEAD><BODY><P>Have you tried:</P><P></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff; font-size: 12pt;">sum</SPAN><SPAN style="font-size: 12pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 12pt;">PROD_GRP_DESC_Dummy</SPAN><SPAN style="font-size: 12pt;"> = <SPAN style="color: #333333;"><SPAN style="color: #ff0000;">{'$(vDummy_Product)'}</SPAN>&gt;}</SPAN></SPAN><SPAN style="color: #333333; font-size: 12pt;">Total_Rel_Rev</SPAN><SPAN style="font-size: 12pt;">) </SPAN></SPAN></P><P></P><P><SPAN style="font-size: 12pt;">?<BR /></SPAN></P></BODY></HTML> Fri, 30 Mar 2012 12:35:40 GMT https://community.qlik.com/t5/QlikView/Include-a-string-in-a-variable/m-p/329952#M1175791 swuehl 2012-03-30T12:35:40Z Include a string in a variable https://community.qlik.com/t5/QlikView/Include-a-string-in-a-variable/m-p/329953#M1175792 <HTML><HEAD></HEAD><BODY><P> Thanks, not sure what I was doing wrong. Its been a long day <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 30 Mar 2012 12:43:02 GMT https://community.qlik.com/t5/QlikView/Include-a-string-in-a-variable/m-p/329953#M1175792 2012-03-30T12:43:02Z