Discussion Board for collaboration related to QlikView App Development.
We want to create a Reloading Schedule task hourly on every month from 1st date to 10 date in Qlik view using Qlik view management console.
how to achieve this.
One option is to create 24 tasks one for each hour with Monthly setting which would allow you to pick all months and first 10 days.
I have not tried this and not sure if this will even work or not... but try to create a single hourly task and then within your script have an if statement which checks the day of the month
If Day(Today()) < 11 then YourScript ELSE
Binary Load of your qvw
The else part might not work as binary load should be on first line of the script(correct me please if i am wrong)
We can instead add a partial reload so the data doesn't get lost. Again this is not tried and just an idea
If Day(Today()) < 11 then YourScript ELSE add load * inline [ dim 1 2 ]; ENDIF;
We have to enable partial reload for that task in QMC. I would be keen to know if this works.
The Windows Task Scheduler might be another option:
For an Action you need to create simple .cmd file like:
"C:\Program Files\QlikView\Distribution Service\QVDistributionService.exe" -r="c:\3.Load\File.qvw"
This works totally fine if you're familiar with Task Scheduler and .cmd files 🙂
You might be right, but why do you think Binary Load won't work? Just looking for obvious reasons that I don't know about.
Qlik help says
"Only one binary statement is allowed in the script and it must be the first statement of the script, even before the SET statements usually located at the beginning of the script."
Because of this i thought binary load may not work. I am not sure how the above condition will behave inside the if statement. Again i would be happy to get corrected in case my understanding is wrong.
Going to give it a shot and see what I find 🙂