topic Re: Schedule QVW files in QMC in QlikView

Schedule QVW files in QMC

Anonymous — Mon, 09 Nov 2015 16:56:41 GMT

Hi experts,

I have requirement like

Having 2 files

a.QVW

b.QVW

I have to run a.QVW file, after loaded this file it got disabled and need to load b.QVW file. This should be run on everyday for 4 hours.

How to do it from QMC.

Regards,

Kumar

Re: Schedule QVW files in QMC

Chanty4u — Mon, 09 Nov 2015 17:24:24 GMT

u can create a triggers......i thnk am nt sure.

Re: Schedule QVW files in QMC

simospa — Tue, 10 Nov 2015 09:11:23 GMT

Hi,

you could do this:

1. create a vEnd variable at the start of the A script and set it as vEnd = 0

2. at the end of reload script of the A file SET vEnd=Today().

3. at the start of reloading of A document you can set a if condition:

IF $(vEnd) <> '0' THEN

insert here all your reload script

END IF

4. set the reload of A document in QMC every 4 hours.

5. set for B document in QMC a reload after A relaod (there is a specific trigger in QMC under Documents --> Reloads).

The A document will be reload every 4 hours, but after the first time the if statement will exclude the real script reloading and then the B reload can start automatically.

Let me know.

Re: Schedule QVW files in QMC

alexandros17 — Tue, 10 Nov 2015 09:17:57 GMT

Go in triggers tab of qmc then press in task dependencies section, here add the task a.Qvw, in this way only when task a. finishes the task b. will start ...

let me know