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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.

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