topic Re: concatenate a ';' in a variable in QlikView

concatenate a ';' in a variable

slondono — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 22 Jun 2017 15:49:12 GMT

use set instead of let

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

oscar_ortiz — Thu, 22 Jun 2017 15:59:35 GMT

You can try:

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

Good luck

Oscar

Anil_Babu_Samineni — Thu, 22 Jun 2017 16:01:58 GMT

Why You need this in Variable? Can you try direct

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

cristianozilz — Thu, 22 Jun 2017 16:41:47 GMT

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 — Thu, 29 Jun 2017 19:15:55 GMT

Sebastian,

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

Thanks

Oscar