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