topic Re: How to use resident in script of qlikview ? in QlikView

How to use resident in script of qlikview ?

suvechha_b — Wed, 11 Sep 2013 11:17:23 GMT

I want to calculate in script by resident ?

eg, Qty : Sum(sale_units)

Value : Sum(sale_units) * Sum ( Value)

NB: sale_units and Value are from different table.

Re: How to use resident in script of qlikview ?

Wed, 11 Sep 2013 11:26:24 GMT

You can create a Temporary table and pull the data from both tables in that (using the appropriate join/concatenation).

Then you can do the calculations using Resident of Temporary table.

Example:

Test1:

Load

A, B

from temp1;

Test2:

Load A,B1,C

from temp2:

The temporary table will be:

Temp :

Load

A, B

from temp1;

Concatenate (Temp)

Load A,B1,C

from temp2:

Finally for calculation:

Load

B*B1,

Resident Temp;

Hope this helps!

Re: How to use resident in script of qlikview ?

Wed, 11 Sep 2013 11:31:32 GMT

Hi,

Please Post your sample file

Re: How to use resident in script of qlikview ?

er_mohit — Wed, 11 Sep 2013 11:39:22 GMT

Resident used for some fields from already loaded table and manually loaded table

for your concern where your field exists in table simply write

sale_units as Qty

sale_units * Value as Value

or if you want sum function then it works with group by clause because it is aggrgate function

after loaded table like

table:

load A,

C from table;

newtable:

load C,

sum(A) as Qty,

sum(B)*sum(A) as Value

resident table group by C;

hope t helps

Re: How to use resident in script of qlikview ?

Wed, 11 Sep 2013 11:52:55 GMT

Is I can understand from your question, you have

Table1 with “Items” and “sale_units” columns and Table2 with “Item” and “Value” columns

In this case you need to join those two tables and get required value

//Join two tables

Left Join(Table1)

Load *Resident Table2;

//Calculate the required Value : Sum(sale_units) * Sum ( Value)

ResultTable:

Load Item, sum(sale_unit)*sum(Value) resident Table1 group by Item;

Re: How to use resident in script of qlikview ?

Thu, 12 Sep 2013 09:20:10 GMT

Hi,

Did this resolve your isue, if so can you please mark the answers as correct/helpful so it will helpful for others to identify.