Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
use set instead of let
if home and dog should be dynamic use dollar sign expansion together with further variables...
You can try:
Let var = 'home'& CHR(059) &'dog';
Good luck
Oscar
Why You need this in Variable? Can you try direct
Trace "'home'&';'&'dog'";
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.
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