topic Re: Concatenate Variables in QlikView https://community.qlik.com/t5/QlikView/Concatenate-Variables/m-p/420983#M156778 <HTML><HEAD></HEAD><BODY><P>Oh, right, Bookmarks. Didn't read correctly. My mistake.&nbsp; Try this then: </P><P></P><P>count({ $(vMeasure) + $(vState) } distinct Units)</P><P></P><P>....or do your variables contain more than one bookmark per variable?</P></BODY></HTML> Fri, 09 Nov 2012 18:04:17 GMT Gysbert_Wassenaar 2012-11-09T18:04:17Z Concatenate Variables https://community.qlik.com/t5/QlikView/Concatenate-Variables/m-p/420980#M156775 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I need to concatenate two variables: vMeasure and vState.</P><P>Do you know how to do it?</P><P>Many Thanks</P><P>Bruno</P><P></P><P> My Expression:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1352482865425315" jivemacro_uid="_1352482865425315"><P>=<SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(<BR />{</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Concat</SPAN><SPAN style="font-size: 8pt;">('$(vMeasure) $(vState)',)<BR />}<BR />DISTINCT<BR />Units) </SPAN></P></PRE></BODY></HTML> Fri, 09 Nov 2012 17:41:20 GMT https://community.qlik.com/t5/QlikView/Concatenate-Variables/m-p/420980#M156775 bruno_m_santos 2012-11-09T17:41:20Z Re: Concatenate Variables https://community.qlik.com/t5/QlikView/Concatenate-Variables/m-p/420981#M156776 <HTML><HEAD></HEAD><BODY><P>try count( $(vMeasure)&amp;$(vState) distinct Units)</P></BODY></HTML> Fri, 09 Nov 2012 17:45:21 GMT https://community.qlik.com/t5/QlikView/Concatenate-Variables/m-p/420981#M156776 Gysbert_Wassenaar 2012-11-09T17:45:21Z Re: Concatenate Variables https://community.qlik.com/t5/QlikView/Concatenate-Variables/m-p/420982#M156777 <HTML><HEAD></HEAD><BODY><DIV><SPAN style="font-size: 8pt;"><DIV>Hi Gysbert,</DIV><DIV>Thanks but doesn´t work.</DIV><DIV>My Variables have bookmarks, that are triggered by buttons.</DIV><DIV> </DIV><DIV>At the end I need a expression like this.</DIV><DIV> </DIV><DIV>Thanks</DIV><DIV>Bruno</DIV><DIV> </DIV><DIV> </DIV></SPAN></DIV><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13524833801934118" jivemacro_uid="_13524833801934118"><SPAN style="font-size: 8pt;"><P>=Count(<BR />{ [Consultas]+ [Realizado]<BR />}<BR />DISTINCT<BR /><BR />UNITS) </P></SPAN></PRE><DIV><SPAN style="font-size: 8pt;"><DIV> </DIV></SPAN></DIV></BODY></HTML> Fri, 09 Nov 2012 17:53:01 GMT https://community.qlik.com/t5/QlikView/Concatenate-Variables/m-p/420982#M156777 bruno_m_santos 2012-11-09T17:53:01Z Re: Concatenate Variables https://community.qlik.com/t5/QlikView/Concatenate-Variables/m-p/420983#M156778 <HTML><HEAD></HEAD><BODY><P>Oh, right, Bookmarks. Didn't read correctly. My mistake.&nbsp; Try this then: </P><P></P><P>count({ $(vMeasure) + $(vState) } distinct Units)</P><P></P><P>....or do your variables contain more than one bookmark per variable?</P></BODY></HTML> Fri, 09 Nov 2012 18:04:17 GMT https://community.qlik.com/t5/QlikView/Concatenate-Variables/m-p/420983#M156778 Gysbert_Wassenaar 2012-11-09T18:04:17Z Re: Concatenate Variables https://community.qlik.com/t5/QlikView/Concatenate-Variables/m-p/420984#M156779 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">I</SPAN> <SPAN class="hps">had</SPAN> <SPAN class="hps">just found</SPAN> <SPAN class="hps">the error</SPAN>. <SPAN class="hps">You</SPAN> <SPAN class="hps">are absolutely right.</SPAN></P><P><SPAN class="hps">Many Thanks</SPAN></P><P><SPAN class="hps">Bruno</SPAN></P></BODY></HTML> Fri, 09 Nov 2012 18:08:17 GMT https://community.qlik.com/t5/QlikView/Concatenate-Variables/m-p/420984#M156779 bruno_m_santos 2012-11-09T18:08:17Z