concatenate a ';' in a variable

[slondono]

Hi experts,

Im having a problem when put ';' in a variable.

Try this please

Let var = 'home'&';'&'dog';

trace var $(var);

Im expecting the string 'home;dog' but there is an error that i dont understand

please. hope you can help me

[Anonymous]

use set instead of let

if home and dog should be dynamic use dollar sign expansion together with further variables...

[oscar_ortiz]

You can try:

Let var = 'home'& CHR(059) &'dog';

Good luck

Oscar

[Anil_Babu_Samineni]

Why You need this in Variable? Can you try direct

Trace "'home'&';'&'dog'";

[cristianozilz · Accepted solution]

The Problem is not in LET command. It's happen when you use Trace.

If you comment the "trace" command and show de variable "var" in a text object you'll see that's is OK.

This happends because the "trace" command understand ';' like a end of command.

[oscar_ortiz]

Sebastian,

If you've found the advice helpful or correct please close this post.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks

Oscar