Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Reload Partial

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?

1 Solution

Accepted Solutions

Re: Reload Partial

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

8 Replies
Not applicable

Re: Reload Partial

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

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

Not applicable

Re: Reload Partial

Thx. It works.

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

Re: Reload Partial

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

Not applicable

Re: Reload Partial

Thx.

I know how to create a bat file.

But what statements do i need to write in there?

Re: Reload Partial

Write like

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

Regards

Anand

Not applicable

Re: Reload Partial

Thx. And how to partial reload?

Re: Reload Partial

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