Add a variable in a table

[#1]

Good morning,

I'm new in Qlikview and I need your help.

I would to add a variable in a table and I can't.

My example:

set va = 111; setvb = 222;

TABLEVALEURPREV : * INLINE [LOAD
PREVCONTRAT,PREVANNEE,PREVTYPE,PREVVALEUR
va,'a','a','a'
vb,'b','b','b'
];

the result: I have va in the table instead of 111 and vb instead of 222.

How I can change add a new record in a table with variables?

Thanks,

Yohann

[masha-ecraft]

Hi Yohann,

try to modify your load script like this:

TABLEVALEURPREV :

LOAD * INLINE [
PREVCONTRAT,PREVANNEE,PREVTYPE,PREVVALEUR
$(va),'a','a','a'
$(vb),'b','b','b'
];

Regards,

Masha

[#3 · Accepted solution]

Hi,

It's ok.

Thanks,

Yohann Frappier