Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Partner
Partner

Running a Qlikview Script before an other Qlikview Script

Hi,

I have 2 Qlikview Scripts. I want to run a Qlikview Script 1 before running Qlikview Script 2 (for loading)

How can i proceed ?

Thanks in advance for your answers

 

1 Solution

Accepted Solutions
Highlighted
kennethmash
New Contributor III

Re: Running a Qlikview Script before an other Qlikview Script

Hi Fanch

Are you simply running a personal edition or do you have a full Qlikview
server environment? Assuming you have qlikview server then you will have a
management console where you can just schedule example 2 to run on
completion of example 1.

If you don't have that then you can use scheduler but I am no expert on
that. I would guess example2 would have to be set to run on an a task that
is triggered by an event from example1 but I am not sure how to do that
unfortunately.

View solution in original post

7 Replies
Highlighted
kennethmash
New Contributor III

Re: Running a Qlikview Script before an other Qlikview Script

Hi, can you post the scripts? I suspect using the preceding load feature can work but can't say for sure without seeing your script. See link below for an explanation of preceding load: https://www.quickintelligence.co.uk/preceding-load-qlikview/
Highlighted
Partner
Partner

Re: Running a Qlikview Script before an other Qlikview Script

In my Qlikview Script 1 Exemple1.qvw

 - Select Tab1, Tab2, Tab 3 from Mytable1

- Store * from Mytable into Path/Mytable1.qvd

In my Qlikview Script 2 Exemple2.qvw

- Select ......

 - Load Tab1, Tab2, Tab 3 from Path/Mytable1.qvd

 

So, i need to update the data from Exemple1.qvw before updating the data from Exemple2.qvw

Highlighted
kennethmash
New Contributor III

Re: Running a Qlikview Script before an other Qlikview Script

Oh ok. Then you just put the script from example2 after the script from example1 in the same document.

So create one document called example 3. In one script tab put the code for example1 and in the other script tab put the code for example2. The tabs are executed from left to right so make sure the tab with the code for example1 is to the left of the tab for the code for example2. You can also just put the code for example2 underneath the code for example1. What you need to do is decide if you need to keep the table from example1. If you don't then just make sure to add the line drop table  "MyTable1" under the store line. If you need to keep the table from example1 then just make sure the example2 table has a different name.

Partner
Partner

Re: Running a Qlikview Script before an other Qlikview Script

Hi Kenneth,

Thanls a lot for your answers, but it is important for me to run from 2 different script, not running 2 script on 2 different tab on the same document. I explain to you

When i reload Exemple1, the time of reload is 23 minutes

When i Reload Exemple2 with Exemple1 on a other tab, the time of reload is 25 minutes

But when i reload Exemple2 with just add loading Exemple1.qvd, the time of reload is just 2 minutes.

So, i need to update the table1 in my Exemple1.qvw (Task Scheduler ? Services ?) , store this information in a qvd file and after update my database in my Exemple2.qvw

Highlighted
kennethmash
New Contributor III

Re: Running a Qlikview Script before an other Qlikview Script

Hi Fanch

Are you simply running a personal edition or do you have a full Qlikview
server environment? Assuming you have qlikview server then you will have a
management console where you can just schedule example 2 to run on
completion of example 1.

If you don't have that then you can use scheduler but I am no expert on
that. I would guess example2 would have to be set to run on an a task that
is triggered by an event from example1 but I am not sure how to do that
unfortunately.

View solution in original post

Highlighted
Partner
Partner

Re: Running a Qlikview Script before an other Qlikview Script

Hi Kenneth,

Yeeeeeeeeeesssss. It's just what i want 👍

Thanks a lot, have a nice day !

Highlighted
kennethmash
New Contributor III

Re: Running a Qlikview Script before an other Qlikview Script

My pleasure!