topic Re: Reload Partial in QlikView

Reload Partial

Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I have a script

ODBC connect ......

ScrA:

SQL <columns>

From

WHERE ....;

ScrB:

sql <columns>

From

Where .....;

Now i want to reload only Scrb:

How to do this?

Re: Reload Partial

Wed, 03 Dec 2014 19:57:31 GMT

Hi Ama,

You can try this

ScrB:

REPLACE

sql <columns>

From

Where .....;

and Finally

File> Partial Reload (Ctrl + Shift + R)

Regards.

Pablo

Re: Reload Partial

its_anandrjs — Wed, 03 Dec 2014 20:03:53 GMT

Hi,

Do this way put Add Load statement above the Sql statement

ODBC connect ......

ScrA:

SQL <columns>

From

WHERE ....;

ScrB:

Add

Load *;

sql <columns>

From

Where .....;

Note:- And then from file menu click on the Partial Reload

Regards

Anand

Re: Reload Partial

Wed, 03 Dec 2014 20:10:00 GMT

Thx. It works.

Can you explain me how to do this automatically every 5 minutes?

Re: Reload Partial

its_anandrjs — Wed, 03 Dec 2014 20:19:48 GMT

Hi,

For this you need the Publisher for reload task and then mount your folder with Qlik application and then create the reload schedule task on the management console and set there time difference. But you need license for this to reload and also the server installation. Also you can create the Bat file for this and then create the task scheduler in the windows platform.

Regards,

Anand

Re: Reload Partial

Wed, 03 Dec 2014 20:24:13 GMT

Thx.

I know how to create a bat file.

But what statements do i need to write in there?

Re: Reload Partial

its_anandrjs — Wed, 03 Dec 2014 20:41:55 GMT

Write like

"c:\Program Files\QlikView\QV.exe" /r C:\FinTestApp.qvw

Regards

Anand

Re: Reload Partial

Wed, 03 Dec 2014 21:01:22 GMT

Thx. And how to partial reload?

Re: Reload Partial

its_anandrjs — Wed, 03 Dec 2014 21:11:04 GMT

Then write /RP

"c:\Program Files\QlikView\QV.exe" /RP C:\FinTestApp.qvw

And dont forget to put Add or Replace in the load statement

Regards

Anand