Group Discounts available for 3+ students and Corporate Clients

Resident Load in Qlikview

Resident Load in QlikView

In some cases, we will need to read the same table more than once in a single script execution. This means, querying the database (or QVDs) and pulling data from it, and then reprocessing that same data after the first read in order to make it adequate for our data model. Since the data is being stored in RAM after each query during the script execution, we can use that RAM-stored data instead of going directly to the original data source. This is accomplished via a Resident load.

Resident Load is used for loading the data from previously loaded tables.

Ex:  Transact:
LOAD Year,

[E:\Qlik View\sales data.xls]
(biff, embedded labels, table is Sheet1$);
load Year, Sales Resident Transact ;

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at, we will update the article in 24 hours.”

0 Responses on Resident Load in Qlikview"

Leave a Message

Your email address will not be published. Required fields are marked *


Please Enter Your Details and Query.
Three + 6