Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i my application am using, 5 table from sql server.
i update any data in one table, how can i reload the particular table in qlikview
script is simple - select * from table.
Hi,
use partial reload in file menu before that add one function in script
which Is the table you are going to reload
like
Replae
Table:
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
Thanks
Manju
Hi Arjun,
In script write 'Add' Prefix above Load or Select statements and save it.
in UI select file menu and select Partial reload or Press ctrl+alt+r.
thanks,
chennaiah
Hi,
Try Partial Reload with Replace, the table which you want to reload just prefix Replace before Load statement
Examples:
Tab1:
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.
Regards,
Jagan.
Hi,
That can be done by using partial reload.
For Eg:
Table:
ADD load * from DataBase_Tabel;
save the the script and come out from script.
And please follow these steps for reload.
1).go to File Tab in UI level
2)then click on Partial Reload
Hope this can helps u.
Thanks,
Raja
Hi Arjun,
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.
Hi Arjun,
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 ).