topic setting value of a variable using a qvd in QlikView

setting value of a variable using a qvd

Wed, 07 Mar 2012 12:26:40 GMT

I want to set a value of a variable from a QVD.

Is it possible?

LET vCOL1 = load distinct valcol from table1.qvd (qvd);

Thanks.

CELAMBARASAN — Wed, 07 Mar 2012 12:31:05 GMT

Hi,

Its possible as below as directly

LET vCol1=FieldValue('valcol',1);

variable:

load distinct valcol as vCol1 RESIDENT table1;

LET vCol1=FieldValue('vCol1',1);

Drop Table variable;

Hope it helps

Celambarasan

Wed, 07 Mar 2012 12:35:21 GMT

thank you very much Celambarasan