topic Variables in script in QlikView

Variables in script

Wed, 01 Dec 2010 09:31:23 GMT

I have a problem with declaring my variable in a load script.

Leeftijd_Map:
Mapping LOAD
$(#CurrentMTO)&'#'&`antwoord_waarde` as antwoord1,
antwoord as AntwoordLeeftijd;
SQL SELECT *
FROM $(CurrentMTO).`antwoord_type` WHERE `antwoord_type_nr` = 5;

What is the right way to declare on the third row.

$(#CurrentMTO)&'#'&`antwoord_waarde` as antwoord1,

Allready thanks a lot.

Greetz,

Dirk

Variables in script

dirk_konings — Wed, 01 Dec 2010 11:09:08 GMT

'$(#CurrentMTO)' & '#' & `antwoord_waarde` as antwoord1

Variables in script

Wed, 01 Dec 2010 11:46:51 GMT

Thanks for the help

I allready found one solution how it works.

'$(CurrentMTO1)#'&`antwoord_waarde` as antwoord1,

Greetz,

Dirk