topic Re: Dynamic Reoad Applicaton in QlikView

Dynamic Reoad Applicaton

vanderson009 — Fri, 17 Nov 2017 17:51:22 GMT

Hi,

How do I create dynamic reload application.

It means I want to schedule my reload on third day of week.

Generally third day is Wednesday, if any holiday occurs on Monday then my third day will be Thursday. In this case I want to schedule my job on Thursday.

Please suggest some options.

Thanks.

Re: Dynamic Reoad Applicaton

vanderson009 — Tue, 21 Nov 2017 06:00:32 GMT

Community team any views on this issue will be appreciated.

Thanks,

Villyee

Re: Dynamic Reoad Applicaton

tresB — Tue, 21 Nov 2017 06:24:44 GMT

Have a look here for few ideas: Schedule Reload task twice per week

Re: Dynamic Reoad Applicaton

PrashantSangle — Tue, 21 Nov 2017 06:34:43 GMT

Interesting ...

How did you going to identify / maintain holiday list?

we can do something like

create calendar in database with all date,day name, holiday flag,and execution flag

execution_flag can daily updated.

logic for execution_flag

if(day(today()-3)='Monday' and holiday_flag='true','0',if(day(today()-3)='Monday' and holiday_flag='false',1,0)) execution_flag

then load that table in new .qvw file

check if execution_flag=1 then execute command.

This is rough thought. It will not solve you issue but might get some help you.

Regards,