topic How to use a table field as a variable ? in QlikView

How to use a table field as a variable ?

Fri, 18 Feb 2011 07:47:38 GMT

Hi,

I just need to know if this is possible.

Once you write the load statement, can I add a where clause to assign a particular value to a variable ?

Example:

SET X= Load FieldValue resident tablename where Fieldvalue='Y';

deepakk — Fri, 18 Feb 2011 07:52:02 GMT

hi Chinmay,

You can use it like

Load fieldValue from table where Fieldvaleu= 'Y';

let vtest = peek('Fieldvalue',0,'tablename');

I hope this helps.

tresB — Fri, 18 Feb 2011 07:54:56 GMT

i think you need something else, otherwise what you wrote is equivalent to

Set X='Y'; if you already know the value then, why not this ? if you are in a different situation, please explain a bi t.

Regards, tresesco

Fri, 18 Feb 2011 09:20:47 GMT

Thanks a lot Deepak

Tue, 22 Feb 2011 07:11:58 GMT

Hi,

I got this working and was trying to use this variable in the where clause but not able to do.

Example:

Load Statement;

let vtest = peek('Fieldvalue',0,'tablename');

Load Statement where Column=$(vtest);