Combine 2 charts into 1

[#1]

Hi,

I have 2 qlikview tables, with ID as the common key. The 2 tables have hours and dates for different tasks. Please see attached qlikview application for details. I am trying to combine the 2 charts to show in 1 chart (with the Incl Qtrs as the horizontal axis and Task1 and Task2 as 2 lines/bars in the chart)

How is this possible?

Thanks in advance!

S

[#2 · Accepted solution]

The simpler solution will be changing the script to concatenate these 2 tables and then you should be able to achieve this easily

TABLE1:

LOAD ID,

     Hrs1,

     Incl_Dates1,

     QuarterName(Incl_Dates1) as Incl_Qtrs1,

'A' as Source

FROM

C:\Users\pqwk\Desktop\DELETE\Book3.xlsx

(ooxml, embedded labels, table is Sheet1);

Concatenate(TABLE1)

TABLE2:

LOAD ID,

     Hrs2 as Hrs1,

     Incl_Dates2 as Incl_Dates1,

     QuarterName(Incl_Dates2) as Incl_Qtrs1,

'B' as Source

FROM

C:\Users\pqwk\Desktop\DELETE\Book3.xlsx

(ooxml, embedded labels, table is Sheet4);

I added additional field Source to differentiate data coming from either source...

Let me know if you need further assistance...