Automate ReLoad of the QlikView JiwaBI model

Owned by Julie Hanlon
Last updated: Mar 12, 2024
2 min read

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:

  1. Log into Qlikview and go to Settings > User Preferences > License tab.
    Copy the 16 digit code.
    Cancel.

  2. 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

  3. ReLoad.  You need to reload otherwise it won't work.

  4. Save again.

  5. Create a batch file with the line:
    "C:\Program Files\QlikView\QV.exe" /r "D:\MyFolder\My JiwaBI file.qvw"
    (including the quote marks).

  6. 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.