Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
its_anandrjs

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

View solution in original post

8 Replies
Not applicable
Author

Hi Ama,

You can try this

ScrB:

REPLACE

sql <columns>

From

Where .....;

and Finally

File> Partial Reload (Ctrl + Shift + R)

Regards.

Pablo

its_anandrjs

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
Author

Thx. It works.

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

its_anandrjs

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
Author

Thx.

I know how to create a bat file.

But what statements do i need to write in there?

its_anandrjs

Write like

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

Regards

Anand

Not applicable
Author

Thx. And how to partial reload?

its_anandrjs

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