Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Fanch
Partner - Creator
Partner - Creator

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
kennethmash
Contributor III
Contributor III

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
kennethmash
Contributor III
Contributor III

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/
Fanch
Partner - Creator
Partner - Creator
Author

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

kennethmash
Contributor III
Contributor III

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.

Fanch
Partner - Creator
Partner - Creator
Author

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

kennethmash
Contributor III
Contributor III

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.
Fanch
Partner - Creator
Partner - Creator
Author

Hi Kenneth,

Yeeeeeeeeeesssss. It's just what i want 👍

Thanks a lot, have a nice day !

kennethmash
Contributor III
Contributor III

My pleasure!