use partial reload in file menu before that add one function in script
which Is the table you are going to reload
one this is done save the Document and come to the front end in file menu u will find one partial reload option click that its automatically that table will get reload
Try Partial Reload with Replace, the table which you want to reload just prefix Replace before Load statement
Replace Select *From Table1;
For loading this you need to follow below steps
1. Come out of the Edit Script window
2. File Menu -> Partial Reload option
Hope this helps you.
Partial load we can load only few tables instead of all the tables available in the document.
Use: Partial Load is very useful in the scenario, where the data changes in less number of tables.
It takes less time to load the few tables.
Few tables will be loaded, which are preceded by ADD/REPLACE statements.
If you can extract the data from SQL server, first go to scripting in qlik view and then select OLEDB and connect the connect button. And then display one pop up window after that select the OLEDB provider. Follow these steps, you will connect and then select tables from SQL server then reload it(reload short cut is ctrl+alt+r ).