Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Luminary
Luminary

Assign value to variable in load time

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?

1 Solution

Accepted Solutions
Highlighted
Valued Contributor

Assign value to variable in load time

Use PEEK() function. See help for example.

View solution in original post

2 Replies
Highlighted
Valued Contributor

Assign value to variable in load time

Use PEEK() function. See help for example.

View solution in original post

Highlighted
Luminary
Luminary

Assign value to variable in load time

Thanks. I used it like this:

Temp:

load FIELD;

;

sql select FIELD from TABLENAME

;

LET variable = PEEK('FIELD');