Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Hi Ama,
You can try this
ScrB:
REPLACE
sql <columns>
From
Where .....;
and Finally
File> Partial Reload (Ctrl + Shift + R)
Regards.
Pablo
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
Thx. It works.
Can you explain me how to do this automatically every 5 minutes?
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
Thx.
I know how to create a bat file.
But what statements do i need to write in there?
Write like
"c:\Program Files\QlikView\QV.exe" /r C:\FinTestApp.qvw
Regards
Anand
Thx. And how to partial reload?
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