topic Re: Need help with -- Garbage after expression in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810577#M1036584 <HTML><HEAD></HEAD><BODY><P>Hi Ruben,</P><P></P><P>I have tried that, but, still receiving the error. I will follow up after I try Collin's suggestions.</P><P></P><P>Thank you</P></BODY></HTML> Fri, 02 Jan 2015 21:30:11 GMT 2015-01-02T21:30:11Z Need help with -- Garbage after expression https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810571#M1036578 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone, please, provide feedback about the cause of the error message, "Error: Garbage after expression...". The message appears in the text object placed on dashboard. I have attached the document for visual presentation of the issue.</P></BODY></HTML> Fri, 02 Jan 2015 16:39:43 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810571#M1036578 2015-01-02T16:39:43Z Re: Need help with -- Garbage after expression https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810572#M1036579 <HTML><HEAD></HEAD><BODY><P>What's vMispolled?</P></BODY></HTML> Fri, 02 Jan 2015 16:49:57 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810572#M1036579 simondachstr 2015-01-02T16:49:57Z Re: Need help with -- Garbage after expression https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810573#M1036580 <HTML><HEAD></HEAD><BODY><P>Have you tried enclosing your variable values you want to concatenate in single quotes:</P><P></P><P><SPAN lang="EN-US" style="color: black;">='</SPAN><STRONG><EM><SPAN lang="EN-US" style="color: gray;">$(vMispolled)' </SPAN></EM></STRONG><SPAN lang="EN-US" style="color: black;">&amp;' of ' &amp; '</SPAN><STRONG><EM><SPAN lang="EN-US" style="color: gray;">$(vTotalStores)'</SPAN></EM></STRONG><SPAN lang="EN-US" style="color: black;"> &amp; ' Stores, ' &amp; </SPAN><SPAN lang="EN-US" style="color: blue;">num</SPAN><SPAN lang="EN-US" style="color: black;">((</SPAN><STRONG><EM><SPAN lang="EN-US" style="color: gray;">$(vTotalStores)</SPAN></EM></STRONG><SPAN lang="EN-US" style="color: black;">-</SPAN><STRONG><EM><SPAN lang="EN-US" style="color: gray;">$(vMispolled)</SPAN></EM></STRONG><SPAN lang="EN-US" style="color: black;">)/</SPAN><STRONG><EM><SPAN lang="EN-US" style="color: gray;">$(vTotalStores)</SPAN></EM></STRONG><SPAN lang="EN-US" style="color: black;">*-1,'##0.00 %') </SPAN></P></BODY></HTML> Fri, 02 Jan 2015 16:51:39 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810573#M1036580 swuehl 2015-01-02T16:51:39Z Re: Need help with -- Garbage after expression https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810574#M1036581 <HTML><HEAD></HEAD><BODY><P>Hi Swuehl,</P><P></P><P>I have tried every way possible.</P><P></P><P>Just for the record - $(vMispolled) is a declared variable. If I just use one of the declared variable that will just provide a '-' (hyphen). Using the complete expression throws the expression error.</P></BODY></HTML> Fri, 02 Jan 2015 17:06:55 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810574#M1036581 2015-01-02T17:06:55Z Re: Need help with -- Garbage after expression https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810575#M1036582 <HTML><HEAD></HEAD><BODY><P>Can you check the value of each variable and test your expression with hard coded numbers.</P></BODY></HTML> Fri, 02 Jan 2015 17:23:20 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810575#M1036582 Colin-Albert 2015-01-02T17:23:20Z Re: Need help with -- Garbage after expression https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810576#M1036583 <HTML><HEAD></HEAD><BODY><P>I tried with the text formula in your word file and given numeric data both variables, shows information OK. I do NOT get the garbage after collection. Can you please post a screenshot of the VALUES for both variables?</P><P></P><P>You may want to try it this way (I tried it both ways and gave the same result, but just in case) --&gt; ='$(vMispolled) of $(vTotalStores) Stores, ' &amp; num($(vMispolled)-$(vMispolled)/$(vTotalStores)*-1,'##0.00 %')</P><P></P><P>By the way, I beleive you have your formula wrong. If you need to show how many Mispolled over TotalStores, your formula should be:</P><P></P><P>$(vTotalStores) - $(vMispolled)/$(vTotalStores)</P><P></P><P>Hope this helps!</P><P></P><P>Regards</P></BODY></HTML> Fri, 02 Jan 2015 18:58:11 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810576#M1036583 2015-01-02T18:58:11Z Re: Need help with -- Garbage after expression https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810577#M1036584 <HTML><HEAD></HEAD><BODY><P>Hi Ruben,</P><P></P><P>I have tried that, but, still receiving the error. I will follow up after I try Collin's suggestions.</P><P></P><P>Thank you</P></BODY></HTML> Fri, 02 Jan 2015 21:30:11 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Garbage-after-expression/m-p/810577#M1036584 2015-01-02T21:30:11Z