topic Re: store same QVD in multiple places in QlikView

store same QVD in multiple places

Anonymous — Fri, 26 Jun 2015 15:50:25 GMT

How to store same qvd in different places, with single store statement (i.e giving two different paths in single store statement)

John

Re: store same QVD in multiple places

sunny_talwar — Fri, 26 Jun 2015 15:51:46 GMT

I don't think you can do it with a single store statement. What's the issue with adding two store statements in the script??

Best,

Sunny

Re: store same QVD in multiple places

Anonymous — Fri, 26 Jun 2015 16:22:53 GMT

I have scenario where I want to place same qvd in three different environments i.e test,dev and prod, where I have to the same for 30 tables

John

Re: store same QVD in multiple places

swuehl — Fri, 26 Jun 2015 16:31:22 GMT

I agree with sunny that this is not possible with a single STORE command.

You can run some command line copy actions from within the script using EXECUTE, if you prefer that over multiple STORE statements (this could also potentially call a multi file copy operation, like copying a complete folder at once).

Re: store same QVD in multiple places

ramoncova06 — Fri, 26 Jun 2015 16:31:33 GMT

you could do a loop for each location

set location1 = 'prod/Table.qvd';

set location2 = 'uat/Table.qvd';

set location3 = 'dev/Table.qvd';

for counter = 1 to 3

store Table into $(location)$(counter)(qvd);