Creating new field using different tables.

[farru_scorpio]

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:

A:

LOAD * INLINE [

    ID, C

    3, 23

    4, 45

    5, 67

];

B:

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

[tresesco]

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

A:

LOAD * INLINE [

    ID, C

    3, 23

    4, 45

    5, 67

];

Join

B:

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]

You are the champ Tresesco