Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Calculated Field using 2 Tables

Hello All,

I am trying to create a calculated field in my script using 2 fields in 2 different tables. I know it's something simple but I would appreciate some help.

1 Reply
Not applicable

Re: Calculated Field using 2 Tables

I don't know if this will help you but here's a simple example:

test:

LOAD * INLINE [

ARTNBR, NUMBER1

3154, 1000

3154, 857

3169, 455

3169, 3542

]

;

inner join

LOAD * INLINE [

ARTNBR, NUMBER2

3154, 50

3169, 222

];

test2:

LOAD *,

NUMBER1 - NUMBER2 as NUMBER_DIFFERENCE

Resident test;

drop table test;

NUMBER_DIFFERENCE is a calculated field using 2 fields in 2 different tables.  I also attached a qvw for additional help if you need it.

Hope this helps!