Combine 2 charts into 1

Tue, 06 Mar 2012 17:09:38 GMT

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!

Combine 2 charts into 1

Tue, 06 Mar 2012 17:14:14 GMT

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...

topic Combine 2 charts into 1 in QlikView

Combine 2 charts into 1

Combine 2 charts into 1