topic Re: load inline using string variables in QlikView

load inline using string variables

Wed, 30 Jan 2013 15:00:29 GMT

Hi,

I'm pretty new to Qlikview.

My primary goal is to store values of variables in something like a map or table. I use the following code in my script. This is a simplified version:

let result = 1;

LOAD * INLINE [

resultValue

$(result)

];

This works fine. The value "1" is visible in the table. But when I change the code to use a string variable, it seems that no value is stored.

let result = "true";

LOAD * INLINE [

resultValue

$(result)

];

I have found many examples where people use integer variables or expressions (like =sum(...)) but no string variables.

Any idea what I do wrong? Is using "Load * Inline ...." the right way at all?

Re: load inline using string variables

Gysbert_Wassenaar — Wed, 30 Jan 2013 15:04:50 GMT

Try using single quotes:

let result = 'true';

LOAD * INLINE [

resultValue

$(result)

];

Re: load inline using string variables

Wed, 30 Jan 2013 15:10:49 GMT

OMG... so simple... this is probably the only thing I did not try.

Thank you for the fast answer!