Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
caccio88
Creator II
Creator II

Configuring an automatic reload twice a month with the QlikView Management Console?

Hi guys,

what I would like to do is to set that my app will be reloaded on the 1st day of the month and on the 15th of the same month.

On the management console I don't have this chance, but only every day, week, month...

So I thought to set the reload every day and change something in my script that doesn't really reload the app if is not the 1st day of the month and on the 15th of the same month, but I simply don't know how...

Any idea?

Thank u all.

Filiberto

stalwar1swuehlgwassenaar

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Configure to reload daily

Use this script

IF Day(Today()) = 1 or  Day(Today()) = 15 then

  // Put your script here

ENDIF

View solution in original post

24 Replies
sasikanth
Master
Master

HI,

Please check the option daily and make it as

For every 15 days and start time .

Please check it once

Thanks

Sasi

swuehl
MVP
MVP

You can also use the EDX trigger mechanism

Using EDX in QlikView 11

and use a command line script triggered by Windows task scheduler to fire the EDX trigger.

The Windows task scheduler can be set up to fire on 1./ 15. each month.

Clever_Anjos
Employee
Employee

Configure to reload daily

Use this script

IF Day(Today()) = 1 or  Day(Today()) = 15 then

  // Put your script here

ENDIF

Anonymous
Not applicable

Hi Filiberto.

Don't have this options?

Clever_Anjos
Employee
Employee

This screen only shows if you´re using a Publisher (not sure if it´s the case)

Colin-Albert

Manuel's screen shows the Trigger options if you have a publisher licence.

If you just have server and no publisher then you can only have one trigger per reload task and do not have this flexibility.

cleveranjos‌ has suggested a workaround.

Set the task to load daily at the time you require, and then add his IF statement around the whole of your load script, so the load only occurs on days 1 and 15.

caccio88
Creator II
Creator II
Author

I think that could work for me.

Thank you so much cleveranjos

swuehl
MVP
MVP

Just take care that you don't end up with an empty data model in your dashboard on all other days

Anonymous
Not applicable

Hi Colin,

Filiberto don't specify if he has Publisher or not, and I am answering if he has this option or not.

I know that this option is only for Publisher.

Thanks.