topic Assign value to variable in load time in QlikView

Assign value to variable in load time

jvitantonio — Tue, 20 Dec 2011 12:41:36 GMT

Hi,

I'd like to know if it if possible to make a query to a DB and assign a value return from the query to a variable while a script is being executed?

luciancotea — Tue, 20 Dec 2011 12:46:03 GMT

Use PEEK() function. See help for example.

jvitantonio — Tue, 20 Dec 2011 13:13:21 GMT

Thanks. I used it like this:

Temp:

load FIELD;

;

sql select FIELD from TABLENAME

;

LET variable = PEEK('FIELD');