Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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;