Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
prasadmundewadi
Contributor III
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

1 Reply
whiteymcaces
Partner
Partner

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

;