topic Re: Running a Qlikview Script before an other Qlikview Script in QlikView

Running a Qlikview Script before an other Qlikview Script

Fanch — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Running a Qlikview Script before an other Qlikview Script

kennethmash — Thu, 20 Jun 2019 08:12:16 GMT

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/

Re: Running a Qlikview Script before an other Qlikview Script

Fanch — Thu, 20 Jun 2019 08:49:05 GMT

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

Re: Running a Qlikview Script before an other Qlikview Script

kennethmash — Thu, 20 Jun 2019 10:33:55 GMT

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.

Re: Running a Qlikview Script before an other Qlikview Script

Fanch — Thu, 20 Jun 2019 12:43:13 GMT

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

Re: Running a Qlikview Script before an other Qlikview Script

kennethmash — Thu, 20 Jun 2019 14:41:17 GMT

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.

Re: Running a Qlikview Script before an other Qlikview Script

Fanch — Thu, 20 Jun 2019 14:51:25 GMT

Hi Kenneth,

Yeeeeeeeeeesssss. It's just what i want 👍

Thanks a lot, have a nice day !

Re: Running a Qlikview Script before an other Qlikview Script

kennethmash — Fri, 21 Jun 2019 07:57:43 GMT

My pleasure!