topic How can I update qvd file automatically as the sql database get updated weekly without physically opening dashboard and reloading? in QlikView

How can I update qvd file automatically as the sql database get updated weekly without physically opening dashboard and reloading?

Anonymous — Fri, 22 Jul 2016 16:12:29 GMT

Hi,

Currently I am using OLEDB connection to load data from sql and then using STORE to save data into a QVD file. Is there a way to update qvd file automatically as the sql database get updated weekly without physically opening dashboard and reloading?

Thanks for the help.

Regards,

Mohammad.

Re: How can I update qvd file automatically as the sql database get updated weekly without physically opening dashboard and reloading?

Clever_Anjos — Fri, 22 Jul 2016 16:27:44 GMT

You need a separated qvw that would be reloaded several times during the day

Re: How can I update qvd file automatically as the sql database get updated weekly without physically opening dashboard and reloading?

Anonymous — Fri, 22 Jul 2016 16:36:24 GMT

Hi Anjos,

I actually get the data refresh just once a week and just want the dashboard to update without physically going in and reloading.

I haven’t done this before, is it possible for you to define the whole process or through an example (that would be great).

Many Thanks,

Mohammad.

Re: How can I update qvd file automatically as the sql database get updated weekly without physically opening dashboard and reloading?

Clever_Anjos — Fri, 22 Jul 2016 17:08:41 GMT

You split the process into 2 qvw.

Runs your SQL and generate a special filetype called QVD (search community for this, a sample generate qvd and store data
Read QVD´s stored by previous step. It should be very, very fast

Re: How can I update qvd file automatically as the sql database get updated weekly without physically opening dashboard and reloading?

Clever_Anjos — Fri, 22 Jul 2016 17:11:03 GMT

This tutorial covers that part http://global.qlik.com/~/media/Files/training/tutorials-qv11/English.ashx

Re: How can I update qvd file automatically as the sql database get updated weekly without physically opening dashboard and reloading?

Fri, 22 Jul 2016 17:34:50 GMT

Hi Mohammad!

Normally the companies use Qlikview Server to schedule the QVW reload. If you want to schedule the reload only using the Desktop version of QV, you can use a schedule program. In Windows (it's just what I know), there is the "Scheduled Tasks" program that can execute commands from a batch file in a period of time. In this case, the bat file (a text file with .bat extension) should have a command line something like this:

c:\Program Files\Qlikview\qv.exe /r YourQVApp.qvw

Hope this helps!

Marcello