topic Re: Multiple reload schedules from QMC in QlikView

Multiple reload schedules from QMC

shambhub — Fri, 31 Oct 2014 13:27:49 GMT

Hi,

I have around 50-60 QVW files, these QVW files should reload 4 times a day according to below mentioned time

Morning Refresh: 4.30 AM

Afternoon Refresh: 1:00 PM

Evening Refresh: 6:PM

Night Refresh : 10:PM

Please any one suggest me to how to schedule using QMC ?, I have tried with different ideas, but I am not able to succeed.

Thank you in advance.

Re: Multiple reload schedules from QMC

maxgro — Fri, 31 Oct 2014 13:59:17 GMT

is it an option to schedule every 30 minutes and, at the beginning of the doc, check the time and force an error when not 4.30 AM, .....?

Re: Multiple reload schedules from QMC

Fri, 31 Oct 2014 14:06:57 GMT

You do not want to force errors if you can help it. Can you trigger them using an EDX? If not I would suggest creating an inline table with an if statement and "exit script" if the time is not matched, you could then schedule this to run every 30 minutes and it shouldn't use much interms of resources.

Re: Multiple reload schedules from QMC

alexpanjhc — Fri, 31 Oct 2014 14:16:38 GMT

This maybe not the best idea, but how about creating 4 same tasks for each file except in the triggers, you have different time?

Re: Multiple reload schedules from QMC

shambhub — Fri, 31 Oct 2014 14:32:09 GMT

Mossimo,

Its not to schedule every 30 minutes, I have to schedule it for 4 schedules according to time which I mentiined in earlier post.

Re: Multiple reload schedules from QMC

shambhub — Fri, 31 Oct 2014 14:33:32 GMT

Alex,

Those are the schedules given by users. I should schedule for the same.

Re: Multiple reload schedules from QMC

shambhub — Fri, 31 Oct 2014 14:34:57 GMT

Felim,

Please can you explain me how can I achieve this with the help of EDX ?

Re: Multiple reload schedules from QMC

alexpanjhc — Fri, 31 Oct 2014 14:37:41 GMT

I do not understand what you are trying to tell me. Is there a reason you can't scheudle for them?

Re: Multiple reload schedules from QMC

shambhub — Fri, 31 Oct 2014 14:51:34 GMT

Alex,

My requirement is very simple, I have schedule reload of QV docs 4 times a day according time below timings

Morning Refresh: 4.30 AM

Afternoon Refresh: 1:00 PM

Evening Refresh: 6:PM

Night Refresh : 10:PM

Please help me achieve this.

Re: Multiple reload schedules from QMC

shambhub — Fri, 31 Oct 2014 15:44:38 GMT

Alex,

I am not able find an option to schedule same report with multiple schedule on same day in QMC

Re: Multiple reload schedules from QMC

maxgro — Fri, 31 Oct 2014 18:05:46 GMT

I think there is a difference

an exit script will save a new version of the doc (maybe without data)

a forced error won't modify the doc

EDX? maybe; it's seems a better solution than force error / exit script

there is some help in the community, just search

Re: Multiple reload schedules from QMC

danielrozental — Fri, 31 Oct 2014 18:18:21 GMT

If you don't have a Publisher license you can only have a single schedule for each QVW.

In my opinion you have two alternatives, run the reload every hour or schedule 4 different QVWs that trigger a reload through EDX http://community.qlik.com/docs/DOC-2650