Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi
Use folowing syntax
var = CHR(39) & 'Unknown' & CHR(39)
39 stands for ASCII code for single quote.
Cheers
Darius
Thanks,
both solutions are working
Regards