topic Re: Need to write #include or variable statement in QlikView

Need to write #include or variable statement

Thu, 31 Mar 2016 23:02:16 GMT

Hi All,

My question related to 1 qvd placed in two different locations.I am having clustered servers : server A and Server B

abc.qvd = placed in "C:\Folder A" and same Qvd placed in C:\Folder B.

server A : sales.qvw access the sale2010.qvd from "C:\Folder A" and qvd accessing from server A.

Server B : sales.qvw access the sale2010.qvd from "C:\Folder B" and qvd accessing from server B.

if server A goes down then server B is active and the sales.qvw will take the qvd from "C:\Folder B" instead of "C:\Folder A".

Folder A belong to Server A and Folder B belong to Server B.

I need to write #include or variable statement to where I can pass the string to sales.qvw and that can pick up the qvd from folder B instead of folder A.

Thanks & Regards,

Gunjesh J

Re: Need to write #include or variable statement

swuehl — Fri, 01 Apr 2016 11:02:52 GMT

Maybe like using this in your script:

Let vPath = If(ComputerName( ) = 'Server A', //check if computer running the script is 'Server A'

'C:\Folder A', // path for server A

If(ComputerName( ) = 'Server B', //check if computer running the script is 'Server B'

'C:\Folder B', // path for server B

'' // Set path when no server matches to empty?

)

Of course you need to adapt the server names to what is returned by OS when calling ComputerName()

ComputerName( )

Returns a string containing the name of the computer as returned by the operating system.

Alternatively, you can use an include statement in your QVW

$(Must_Include=Paths.qvs);

And use two distinct files on each server with a different LET statement to define the path

Let vPath = 'Server A';

resp.

Let vPath = 'Server B';

Hence having the same QVW on both server, but different qvs.

With all approaches, use the vPath variable in your qvd load statements:

LOAD *

FROM [$(vPath)\sale2010.qvd] (qvd);

Or maybe consider just using 1 QVD on 1 location?

Regads,

Stefan

Re: Need to write #include or variable statement

Fri, 01 Apr 2016 15:11:34 GMT

Hi Stefan,

Thanks for replying.

I just wanted to know "Paths.qvs" containing which code?

What I understood.

There are two ways I can achieve after seeing your code.

either This,

Let vPath = If(ComputerName( ) = 'Server A', //check if computer running the script is 'Server A'

'C:\Folder A', // path for server A

If(ComputerName( ) = 'Server B', //check if computer running the script is 'Server B'

'C:\Folder B', // path for server B

'' // Set path when no server matches to empty?

)

This the path of qvd's : 'C:\Folder A', where qvd store for server A right ?// path for server A?

This the path of qvd's : 'C:\Folder B', where qvd store for server B right ?// path for server A?

second statement :

$(Must_Include=Paths.qvs);

And use two distinct files on each server with a different LET statement to define the path

Let vPath = 'Server A';

resp.

Let vPath = 'Server B';

Hence having the same QVW on both server, but different qvs.

Re: Need to write #include or variable statement

swuehl — Fri, 01 Apr 2016 15:23:47 GMT

You would have two distinct Paths.qvs, one for each server. Both qvs files are named the same, but containing different Let statements.

And yes, I described two different approaches, one using ComputerName(), one using include files.

Does this clarify your concern?

Re: Need to write #include or variable statement

Mon, 04 Apr 2016 16:16:44 GMT

Hi Stefan,

Thanks!!!

in path.Qvs what path we have to mention? if we are $(Must_Include=Paths.qvs);?

Paths.QVS = vPath = 'Server A'; and vPath = 'Server B';? or path for QVD's stored in different location?

i.e.

the path of qvd's : 'C:\Folder A', where qvd store for server A right ?// path for server A?

This the path of qvd's : 'C:\Folder B', where qvd store for server B right ?// path for server A?

Re: Need to write #include or variable statement

swuehl — Mon, 04 Apr 2016 16:32:53 GMT

Sorry, I don't understand the question.

You have two servers, ServerA and ServerB, right?

You have the same QVW on both servers, right?

Then you need to add the include statement to the QVWs, and put a Paths.qvs file in the same folder where the QVW reside.

The name of this file is the same, Paths.qvs, so it can be included from both QVW without any change.

The content is different, defining the paths to your QVD specifically for each server, using LET as shown above.

Re: Need to write #include or variable statement

Mon, 04 Apr 2016 18:14:42 GMT

hi,

My question is what we have to put in Path.qvs ?

Thanks

Re: Need to write #include or variable statement

swuehl — Mon, 04 Apr 2016 18:48:26 GMT

A single line

Let vPath = 'C:\Folder A';

for server A, Replace the path on the other server accordingly.