If you have a large database or are fetching a lot of history, the reload of the QlikView / JiwaBI model can take a long time. We consider more than 10 minutes a long time.
It’s possible to automate the reload function at a quiet time, or after hours, so the reports are ready for you without waiting around. Here’s how:
Log into Qlikview and go to Settings > User Preferences > License tab.
Copy the 16 digit code.
Cancel.Go to the Admin tab and in the Auto Refresh Serial, click the button and paste into the code window. OK.
Don’t just paste the code into the field – you need to click the ellipsis button. Remove any carriage return.
Save
ReLoad. You need to reload otherwise it won't work.
Save again.
Create a batch file with the line:
"C:\Program Files\QlikView\QV.exe" /r "D:\MyFolder\My JiwaBI file.qvw"Use Windows Task Scheduler to schedule running the BAT file.
5. To create a batch file, open Notepad
Enter the text from step 5, including the quote marks.
Make sure you insert your own values for the drive, folder and model name after /r
Save the Notepad file as ‘QV ReLoad.bat’ on your hard drive
6. To create a scheduled task using Windows Task Scheduler
Type Task Scheduler in the Windows search bar and launch the Task Scheduler app.
From the Action menu, select Create Basic Task
Follow the prompts in the Task Wizard to define your frequency of reload
At the Action section, select ‘Start a program’. The program will be your batch file.
Click the Browse button on the following screen to select your .bat file
Click Finish
To edit your Task later, right-click on the task in the Task Scheduler Library folder and select Properties.
