topic Choose connection string based on computer name in QlikView

Choose connection string based on computer name

Tue, 31 Jan 2012 23:29:24 GMT

I have a connection string that works on one pc, but not on the other, and vice versa..

So two connection strings.

What I want to do is have an if satement that checks the computer name, and if its computer A, then use connection 1, else use connection 2.

How do I do this?

rbecher — Wed, 01 Feb 2012 08:22:43 GMT

Hi,

just do it like this:

if ComputerName() = 'COMPUTER_A' then

CONNECT DB1....;

elseif ComputerName() = 'COMPUTER_B' then

CONNECT DB2....;

else

exit script;

end if

- Ralf