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
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
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.
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