Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik
I am trying to get a result can anybody help me here?
//2 Data sets below
Table1:
load * Inline
[
Day1,Measure1
1,20
2,30
3,50
4,25
5,45
];
Table2:
load * Inline
[
Day2,Measure2
1,50
2,40
3,30
4,20
5,10
];
-------------------------------
Note: Day1 and Day2 are different dimensions here.
Need to get a resultant table as Day and sum of the 2 measures from 2 tables above.
Day Measure
1 70 (20+50)
2 70 (30+40.. ans so on)
3 80
4 45
5 55
I would put both tables into 1 table in the script.
Table1:
Load * InLine
[Day1,Measure1
1,20
2,30
3,50
4,25
5,45
];
Table2:
Load * InLine
[Day2,Measure2
1,50
2,40
3,30
4,20
5,10
];
Data:
Load
Day1 as Day,
Measure1 as Measure
Resident Table1
;
Concatenate (Data)
Load
Day2 as Day,
Measure2 as Measure
Resident Table2
;