Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
t_vijay_qlik
Contributor III
Contributor III

Re:Resident load

Hi all,

when we are doing the resident load in qlikview can anyone explain the where condintion usage in resident load

Thanks

Vijay Kumar

1 Solution

Accepted Solutions
balabhaskarqlik

Resident Load can be used to load data from a previously loaded table. In Resident Load, we can do a calculation or transformation. It is very simple to load an existing field and table also. It is a highly important feature of QlikView because by using Resident Load, we perform a calculation on an existing field and table also.

Small Example:

City:

Load * inline

[

Name,Sales,Year

Africa,250,2011

Montana,580,2013

Durban,489,2017

];

TotalCheck:

Load

    Name,

    Sum(Sales) as TotalValue

Resident City

Group by Name;

Drop Table City;

View solution in original post

7 Replies
balabhaskarqlik

Resident Load can be used to load data from a previously loaded table. In Resident Load, we can do a calculation or transformation. It is very simple to load an existing field and table also. It is a highly important feature of QlikView because by using Resident Load, we perform a calculation on an existing field and table also.

Small Example:

City:

Load * inline

[

Name,Sales,Year

Africa,250,2011

Montana,580,2013

Durban,489,2017

];

TotalCheck:

Load

    Name,

    Sum(Sales) as TotalValue

Resident City

Group by Name;

Drop Table City;

View solution in original post

agarwalrits13
Contributor III
Contributor III

Hi Vijay,

Below is the qlikview Help link which gives detail information about resident load.

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/load-data-from-previousl...

qlikviewwizard
Master II
Master II

Hi Vijay,

Please check this. Let me know if you did not not understand.

Loading data from a previously loaded table

There are two ways to load and transform data from a table that already has been loaded.

  • Resident LOAD - where you use the Resident predicate in a subsequent LOAD statement to load a new table.
  • Preceding load - where you load from the preceding LOAD or SELECT statement without specifying a source.
  • Resident or preceding LOAD?
  • Resident LOAD

Resident or preceding LOAD?

In most cases, the same result can be achieved by using either method. A preceding LOAD is generally the faster option, but there are some cases where you need to use a Resident LOAD instead:

  • If you want to use the Order_by clause to sort the records before processing the LOAD statement.
  • If you want to use any of the following prefixes, in which cases preceding LOAD is not supported:
    • Crosstable
    • Join
    • Intervalmatch

Resident LOAD

You can use the Resident predicate in a LOAD statement to load data from a previously loaded table. This is useful when you want to perform calculations on data loaded with a SELECT statement where you do not have the option to use Qlik Sense functions, such as date or numeric value handling.

Example:

In this example, the date interpretation is performed in the Resident load as it can't be done in the initial Crosstable LOAD.

PreBudget: Crosstable (Month, Amount, 1) LOAD Account, Jan, Feb, Mar, …

From Budget; Budget: Noconcatenate

LOAD Account, Month(Date#(Month,’MMM’)) as Month, Amount Resident PreBudget;

Drop Table PreBudget;

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/load-data-from-previousl...

MindaugasBacius
Partner
Partner

In Resident load Where condition can be used the same as in Load statement.

balabhaskarqlik

If you got the answer, mark it as Answered and close the thread.

pintucs20
Contributor III
Contributor III

Hi Vijay,

Yes, you can use before and after drop table, its  not matter when you want to use .

its is working in both situation.

Thanks