topic Re: Load a list from a select statement to variable in QlikView

Load a list from a select statement to variable

Tue, 31 Dec 2013 10:53:30 GMT

Hi.

I need to load a list to a var from a select.

For example:

Select distinct client_code

From sales

Output: 1,3,4,5

I need the var to have:

vClients = 1,3,4,5;

Thank You.

Anonymous — Tue, 31 Dec 2013 10:55:52 GMT

Gil

Use the Concat() function, see the Qv Desktop Help for its syntax.

Best Regards, Bill

Peter_Cammaert — Tue, 31 Dec 2013 11:04:55 GMT

This is one way to do it in your script. Note: Concat() is an aggregation function that cannot be used in a simple variable assignment.

See attachment.

Best,

Peter