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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

setting value of a variable using a qvd

Hi

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.

Labels (1)
1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Its possible as below as directly

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

or

variable:

load distinct valcol as vCol1 RESIDENT table1;

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

Drop Table variable;

Hope it helps

Celambarasan

View solution in original post

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Its possible as below as directly

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

or

variable:

load distinct valcol as vCol1 RESIDENT table1;

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

Drop Table variable;

Hope it helps

Celambarasan

Not applicable
Author

thank you very much Celambarasan