Set Variable in Scrip vs Dashboard

[sebastian_fager]

Hi,

I have i problem. The variable works in the dashboard but not in the script. It looks like it cuts of my ' in the end, why?

Script:

Dashboard(Script):

Dashboard Script(and works):

[marcus_sommer]

Try it with:

set = "YourExpressionIncludingSomeSingleQuotes";

- Marcus

[sebastian_fager]

Hi,

The script runs without error, but the variable dashboard is blank..

[andrespa]

Hi Sebastian, it's as Marcus said. Please have a look to this:

LET and SET

That may clarify the difference in using SET and LET

Hope it helps,

Andrés

[sasiparupudi1]

You can try

let vPackCare='if(len(RavaraNr)=5 and Left(RavaraNr,1)=3,sum(levAntalRavara)/ArtikelVikt),'& chr(39)& chr(39)&')';

[rwunderlich · Accepted solution]

To represent a quote within the string, code the single quote twice. So a pair of single quotes would be coded as.

LET v1 = 'if(x,y,'''')';

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[sebastian_fager]

Thanks works now!