Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

prasadmundewadi
New Contributor III

2 Dim 2 measure need to be combined in 1 chart

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

Tags (2)
1 Reply
whiteymcaces
New Contributor III

Re: 2 Dim 2 measure need to be combined in 1 chart

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

;

Community Browser