Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with LOAD INLINE with variables

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?

4 Replies
Clever_Anjos
Employee
Employee

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

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

Clever_Anjos
Employee
Employee

We learn new things every day

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

sunny_talwar

Well said