topic Re: Creating new field using different tables. in QlikView

Creating new field using different tables.

farru_scorpio — Wed, 30 Aug 2017 06:16:21 GMT

Dear Experts,

I am new to qlikview and I am struggling to reach a solution but end up with no success. I have two tables e. g as below:

LOAD * INLINE [

ID, C

3, 23

4, 45

5, 67

];

LOAD * INLINE [

ID, A, B

1, FHF, 99

3, GFHF, 900

4, TRYR, 800

7, ERW, 250

];

I want new filed as "D" calculating "B+C". "B" from table B: and "C" from A: Please assist.

Farrukh

tresB — Wed, 30 Aug 2017 06:20:25 GMT

First join the tables and then calculate the new field like:

LOAD * INLINE [

ID, C

3, 23

4, 45

5, 67

];

Join

LOAD * INLINE [

ID, A, B

1, FHF, 99

3, GFHF, 900

4, TRYR, 800

7, ERW, 250

];

NoConcatenate

final:

Load

RangeSum(B,C) as NewField

Resident A;

Drop table A:

farru_scorpio — Wed, 30 Aug 2017 06:26:25 GMT

You are the champ Tresesco