Can I put a command in the script of one QlikView file that will open and run another QlikView file?

[#1]

Currently I have a file running on a schedule that downloads global information from one of our databases and exports the info into qvd files for others to use.

The requirement for this doc initially at least is for it to be used by a single region. I have tried using locked selections so that only their data can be selected but apparently it's really confusing them and so I need to exclude completely data not relevant to their region.

The easiest way to do this is to download, save into qvd, drop tables and reload with a where clause to only include their region. This probably best scheduled as two individual files (one data one report) but rather than setting yet another file on the schedule (it's not me that does it and I'm trying not to make work for others) I was wondering if there was any way I can put a script on the report file to trigger the data file to reload.

Any ideas?

Thanks, Emma

[#2]

Hi Emma,

if you work with user access (security), you can give people access to their region only. Then they don't see data related to other regions.

But if you really want to reload a qvw with another, try the following:

execute "C:\ProgramFiles\QlikView\Qv.exe" /R /NoSecurity "X:\location_qvw\name_qvw_file.qvw"

Regards

Reyman

[#3]

Hi,

Many thanks for that and it looks like it should work ... only problem is it just freezes my script run and I have to close the application through task manager to be able to continue.

Any idea why?

I'm using V9 SR4

Cheers,

Emma

[#4]

Hi Emma,

I think it's a known bug in the qlikview reload script.

When you edit the script and then reload, it normally loads the way it should,

but when you are looking in the report and then press the reload button, it will reload as normal, but it doesn't show the progress of the script.

Then it looks like your script ain't working correct, but in the background it is working.

I hope this is what you mean.

Regards,

Rey-man