topic How to use a variable value as a string in a Load instruction ? in QlikView

How to use a variable value as a string in a Load instruction ?

Tue, 13 Apr 2010 12:39:09 GMT

Hi,

I'm trying to do a simple thing in a script (QlikView Desktop V9):
I've a variable :

SET V_UNKNOW_MARKET='Unknow' ;

then further in the script, I want to use this value :

LOAD
autonumber( [Region] & '/' & $(V_UNKNOW_MARKET)) as KEY
....

So it's quite simple, but with this syntax, QlikView understand the string 'Unknow' as a fieldname : Unknow.
I'm fighting with the syntax (using LET, SET, $(=) ...)

Do you know how to specify that the variable value is a constant string ?

Best regards

How to use a variable value as a string in a Load instruction ?

stephencredmond — Tue, 13 Apr 2010 12:44:52 GMT

Hi,

The dollar expansion will just replace the string literal in your script. You need to include the quotes for it:

LOAD
autonumber( [Region] & '/' & '$(V_UNKNOW_MARKET)') as KEY

Stephen

How to use a variable value as a string in a Load instruction ?

d_pranskus — Tue, 13 Apr 2010 12:45:39 GMT

Use folowing syntax

var = CHR(39) & 'Unknown' & CHR(39)

39 stands for ASCII code for single quote.

Cheers

Darius

How to use a variable value as a string in a Load instruction ?

Tue, 13 Apr 2010 12:56:47 GMT

Thanks,
both solutions are working

Regards