topic Re: Reload If Weekday between 8am - 5pm in QlikView

Reload If Weekday between 8am - 5pm

Fri, 23 Oct 2015 20:34:38 GMT

Hi All

I have this script in my model(s) to test whether its between 8a and 5pm or Sat or Sun and not last day of month else Exit Script:

IF Hour(Now()) > 17 and Hour(Now()) < 7 or DayName(Today()) = 'Sat' or 'Sun' and Day(Today()) <> Day(MonthEnd(Today())) THEN

Exit Script;

END IF;

Problem is, the task schedule reloads this model, runs this script and exits. This means my data in the model is all gone as nothing loaded as the script exited?

I am looking for the model to only reload as stipulated otherwise nothing. This works well for my models which are simply models to reload my QVD files, but the visual models end up being empty on the Access Point?

Any help please?

Re: Reload If Weekday between 8am - 5pm

santiago_respane — Fri, 23 Oct 2015 21:24:29 GMT

Maybe if you separate your app in layers, this could help:

1 - Extract layer: Reload condition goes here. Update QVDS only if condition is false, otherwise use the "exit script" sentence and QVDS will remain the same.

2 - UI layer: load from existing QVDS. In this layer its irrelevant if QVDS where updated or not

Let me know if this helps,

Kindest regards,

Re: Reload If Weekday between 8am - 5pm

lironbaram — Sat, 24 Oct 2015 04:53:02 GMT

what i did in this case

i added a qv model that only checks the rule and failed if the rule don't apply

then in the reload schedule i set the target model to load only if the new model succeeded

the only downfall for this is that you'll have in your qmc a model that failed in the weekends and nights

Re: Reload If Weekday between 8am - 5pm

Sat, 24 Oct 2015 06:41:13 GMT

‌thanks Santiago

i have my qvd's being updated by one qvw model. Dependent on its successfull running i then reload my visual models one after another. So would i just have a qvw with the above script to test the dsy of week, hour of day and last day of month and if it is fail it on purpose so the the dependent reloads do not happen?

thing is, i also dont want these visual reloads running unless falls i to the scripted time frames?

Re: Reload If Weekday between 8am - 5pm

HirisH_V7 — Sat, 24 Oct 2015 07:20:38 GMT

Dear Santiago ,

Please post a sample app . as of my request .

Thanks,

hirish