topic Re: 2 JOBS IN QMC in QlikView

2 JOBS IN QMC

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

Hi Team,

I am handling scenario in my project as,

My dashboard will get refresh only on Monday, but the scenario is my dashboard should also get refresh in first weekday for every month.
if the first weekday of the month is Sunday or Saturday it should be skipped and refreshment should start on first weekday.

So i planned to schedule 2 jobs in QMC for refreshment on every monday and first weekday for every month, Is there possibilities to skip Sunday or Saturday in QMC

Please provide your suggestion. Thanks in Advance.

Regards,

ASHOK RAVICHANDRAN

Re: 2 JOBS IN QMC

agarwalrits13 — Tue, 24 Jul 2018 02:39:34 GMT

HI Ashok,

We can create 2 dummy task, one which we run and every monday and other with run starting 7 days of month. And then create 3rd task which will be depended once both task ran successfully.

Re: 2 JOBS IN QMC

agarwalrits13 — Tue, 24 Jul 2018 02:43:01 GMT

HI Ashok,

Just now I verify differenet was in QMC, There is a way in QMC which can be done with done task itself. I have attached the screen shot of the triggers section. Please Click "On" readio button in order to view this.

Re: 2 JOBS IN QMC

pooja_prabhu_n — Tue, 24 Jul 2018 09:57:49 GMT

Hi,

refer this

Qlikview refresh - run everyday except sundays?

Thanks,

Pooja

Re: 2 JOBS IN QMC

Anonymous — Tue, 24 Jul 2018 13:31:11 GMT

Thanks Pooja, Your reference is helpfull

Re: 2 JOBS IN QMC

andrei_delta — Tue, 24 Jul 2018 14:25:13 GMT

in qmc, when you configure the trigger you select on a schedule and untick the days you don't want to reload the doc.

Re: 2 JOBS IN QMC

Anonymous — Wed, 25 Jul 2018 10:42:56 GMT

Thanks for your suggestion Ritesh, I will work on it and get back.

Re: 2 JOBS IN QMC

agarwalrits13 — Wed, 25 Jul 2018 16:55:11 GMT

Hi ashok_ravichandran‌

Please mark the correct answer if the logic is working as per your requirement. So that it will help others too.