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

What is meant by partial reload? What is its use? Please explain!

Hi All,

What is meant by partial reload? What is its use? Please explain!

Thanks,

Attitude

22 Replies
Not applicable
Author

As you know :

Partial Reload is used whenever you just want to add some new data without reloading all other tables.

Use partial reload if and only if you want to see the result of an insertion in your qlikview app real time, and your app include some set analysis and "if and else" statement. for example, Imagine you have a database and your qlikview is connected to your database , once some one insert a new record to your db (using an other app like .net or php) you want to see the result on your qlikview app instantly. However, if you use partial reload your application calculation time is still there. if you don't have set analysis in your app you still can use direct discovery. in 90% of cases instead of Partial Reload, incremental reload can solve your problem.

Not applicable
Author

it's worth noting that, NOCONCATENATE doesn't play nicely with REPLACE keyword

as the qlikview engine seems to try to load the new part first before dropping the old one, and hence NOCONCATENATE is present, it forces the engine to create a new table name called (tab1-1) for instance.

this way the REPLACE keyword fails to delete the old instance as its name is now changed.

taha_mansoor
Creator
Creator

link is not showing the said vdo