Discussion board where members can get started with QlikView.
I am new to Qlikview
How to Create Resident Load?
Go to Solution.
Resident load in qlik is loading data from previously loaded table.
Following is example:
load * inline [
load * resident table1 where Sales = 10000;
In table2 only one records will be loaded from table 1 because of where condition.
i.e for india sales = 10000
load * inline 
load * resident table table1 where sales = 10000;
First load a table from some source
LOAD * INLINE [
Then use a resident load to create a new table with data from the first table:
FieldA as FieldB
Resident LOAD - When you load data from existing table in the memory.
Let suppose you load data from Excel file with this script into table Sample_Data:
FROM [lib://Desktop/Sample Data.xlsx]
Now you want to make some modification into the same table and reload again, you can use resident load and drop the original table.
[Measure X]*365 as [Yearly Measure]