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

Announcements
Join us in Bucharest on Sept 18th 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