topic Re: Problem with LOAD INLINE with variables in QlikView

Problem with LOAD INLINE with variables

Tue, 16 Jun 2015 20:34:46 GMT

i have this:

LOAD * INLINE [

OrdenEVA2, ConceptoEVA2, ValorEVA2, MesEVA2, AñoEVA2

3, 'Crecimiento Real', ($(vVenta)/$(vVentaAnt))-1)-$(vInflacion), $(vMes), $(vAño)

];

let vNum1=1;

let vNum2=10;

LOAD * INLINE [

Num1, Num2, Num3, Name

1, 10, $(vNum1)+$(vNum2), 'Francisco'

];

when i see the data in a Simple Table, the operation for Num3 is not the sum... is exactly : '$(vNum1)+$(vNum2)' ...

I mean, the script is not evaluating the sum.

Why?

Clever_Anjos — Tue, 16 Jun 2015 20:37:24 GMT

Try this

let vNum1=1;

let vNum2=10;

LOAD Num1, Num2, evaluate(Num3) as Num3, Name INLINE [

Num1, Num2, Num3, Name

1, 10, $(vNum1)+$(vNum2), 'Francisco'

];

sunny_talwar — Tue, 16 Jun 2015 20:40:58 GMT

Awesome Clever Anjos‌, learned a new things from you today.

Clever_Anjos — Tue, 16 Jun 2015 20:43:08 GMT

We learn new things every day

"I am learning all the time. The tombstone will be my diploma". ~Eartha Kitt

sunny_talwar — Tue, 16 Jun 2015 20:46:46 GMT

Well said