topic Assign SQL result to script variable in QlikView

Assign SQL result to script variable

Wed, 18 Apr 2012 19:00:53 GMT

Hi,

I would like to assign the result of an SQL request in a script variable:

SET var='';

SELECT CONCAT(id,';') AS idlist

FROM table;

How do I assign idlist value (for example '1;5;7;10') to var?

I tried var=idlist but get an empty result.

Thanks

Jason_Michaelides — Wed, 18 Apr 2012 20:04:56 GMT

LOAD

idlist

;

SQL SELECT

CONCAT(id,';') AS idlist

FROM table;

LET var = Peek('idlist');

This will place the last loaded value of idlist into the variable 'var'.

Hope this helps,

Jason