Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
farru_scorpio
New Contributor III

Creating new field using different tables.

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

2 Replies
MVP
MVP

Re: Creating new field using different tables.

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

Re: Creating new field using different tables.

You are the champ Tresesco

Community Browser