Assign variable from previous qvd in script

alejo13qv — Mon, 25 Aug 2014 13:07:54 GMT

Hi colleagues this might be easier than I thought but I am stuck and need guidance.

I have a list of clients stored in a qvd (clients.qvd) which I then join to a SQL query in my script. This list may suffer changes like new or deleted clients.

Considering those possible changes I have been trying to assign the client id to a variable to then use it in the SQL query without having to join, by doign this the sql query becomes more efficient..

When running the Debugger I see the qvd is pulled correclty with data however the variable does not obtain the ClientId value/s:

Script:

Clients:

LOAD distinct ClientId

FROM [..\QVD\ClientsList.qvd] (qvd);

LET vCCode = Concat(CLientId,',');

Debugger output:

vCCode <NULL>

ClientId <NULL>

I am sure I am overlooking something here, any help will be greatly appreciated, thanks!

Re: Assign variable from previous qvd in script

jonathandienst — Mon, 25 Aug 2014 13:18:06 GMT

Clients:

LOAD distinct ClientId

FROM [..\QVD\ClientsList.qvd] (qvd);

ClientList:

LOAD Concat(ClientId, ',') As ClientList

Resident Clients;

LET vCCode = Peek('ClientList');

DROP Table ClientList;

HTH

Jonathan

Re: Assign variable from previous qvd in script

alejo13qv — Mon, 25 Aug 2014 13:44:08 GMT

Thank you Jonathan!

topic Re: Assign variable from previous qvd in script in QlikView

Assign variable from previous qvd in script

Re: Assign variable from previous qvd in script

Re: Assign variable from previous qvd in script