Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
t_vijay_qlik
New 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
Honored Contributor

Re:Resident load

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
Honored Contributor

Re:Resident load

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

balabhaskarqlik
Honored Contributor

Re:Resident load

agarwalrits13
New Contributor III

Re:Resident load

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
Honored Contributor II

Re:Resident load

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
Valued Contributor III

Re:Resident load

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

balabhaskarqlik
Honored Contributor

Re:Resident load

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

pintucs20
New Contributor III

Re:Resident load

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