Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combine 2 charts into 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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

1 Reply
Not applicable
Author

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