Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ebrahimaljefri
New Contributor III

new calculated field between 2 tables

hi

i am using qlik sense desktop and i want to know what is the proper logic to create new calculated field and the aggregation contain a field from table 1 and another filed from table 2 to be created in load editor either in table 1 load or table 2 

2 Replies
dberkesacn
Contributor III

Re: new calculated field between 2 tables

You can use such a code like this:

Table1:

LOAD * INLINE [

    Dimension, MeasureA

    Dim1, 10

    Dim2, 20

    Dim3, 5

];

Table2:

left Join(Table1)

LOAD  *  INLINE [

    Dimension, MeasureB

    Dim1, 12

    Dim2, 23

    Dim3, 4

];

Table3:

LOAD

*,

MeasureB  *  MeasureA as MeasureC

Resident Table1;

DROP Table Table1;

But you can make expression in the front end for example in the List Box object.

Basic principle is do every calculation in the backend if it is possible.

Daniel

balabhaskarqlik
Honored Contributor

Re: new calculated field between 2 tables

Try this:

TempBudgetUSA:

CrossTable(DocumentDate, Amount, 3)

LOAD Sale,

Include,

[Account No],

FROM

(ooxml, embedded labels, table is Sheet1) where Include = 'y';

left join (TempBudgetUSA)

TempBudgetUK:

CrossTable(DocumentDate, Amount, 3)

LOAD Sale,

Include,

[Account No],

FROM

(ooxml, embedded labels, table is Sheet1) where Include = 'y';

Final:

Noconcatenate

Load

Max(Include) as MaxIncl,

Sum(Sale) as SumSale

Resident TempBudgetUSA

Group by Sale,  Include,  [Account No];

Drop table TempBudgetUSA;