topic String variable in script in QlikView

String variable in script

Thu, 05 Apr 2012 10:05:32 GMT

Hello,

I am trying to define a string variable and use it in a script. It works fine if I create the variable in the Variable Viewer:

Variable name = Status

Value = 'OK'

LOAD

INFO,

if(INFO=$(Status), $(Status), 'KO') AS INFO2

FROM file.xlsx [...];

But when I try to declare the variable in the script it fails:

SET Status='OK'; //I also tried SET Status="OK";

LOAD

INFO,

if(INFO=$(Status), $(Status), 'KO') AS INFO2

FROM file.xlsx [...];

Error:

Field not found <OK>

if(Status=OK,OK,'') AS INFO2

Quotes around 'OK' are removed so string OK is seen as a field name instead of a string value. If you look at the variable in the Variable Viewer:

Variable name = Status

Value = OK <------- quotes are missing

How to keep the quotes to make sure the variable is interpreted as a string and not a field name?

Thu, 05 Apr 2012 10:17:57 GMT

Hi,

try with this:

LOAD

INFO,

if(INFO='$(Status)', '$(Status)', 'KO') AS INFO2

FROM file.xlsx [...];

regards

vijay_iitkgp — Thu, 05 Apr 2012 10:20:35 GMT

Hi,

Put your variable under quotes:

if(INFO='$(Status)', '$(Status)', 'KO') AS INFO2

Thu, 05 Apr 2012 10:22:22 GMT

It works like a charm! (I indeed got misleaded by the syntax editor coloring)

Thank you very much!