topic Add a variable in a table in Water Cooler

Add a variable in a table

Tue, 24 Apr 2012 06:49:14 GMT

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

Add a variable in a table

masha-ecraft — Tue, 24 Apr 2012 10:59:47 GMT

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

Re: Add a variable in a table

Tue, 24 Apr 2012 11:18:46 GMT

Hi,

It's ok.

Thanks,

Yohann Frappier