Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
apoorvasd
Creator II
Creator II

Data for multiple date fields to be displayed in a single line chart.

Hello everyone,

I have a requirement where the data is being pulled from excel sheet and the format is as follows: AOP and Forecast are in the format as shown in the attached screenshot. I have used the cross table concept and have brought in the month columns under one field. Now what I am trying to do is, create a line chart for forecast for F/T/O values that is in the excel sheet like shown in the picture which is related to months under forecast. Similarly we need to have a target AOP trend in the same chart (cumulative), but that corresponds to months under AOP. I am able to show two different graphs for this but unable to combine them under one. How can I achieve this? Is it possible?

Note: At the script side I have loaded months that come under forecast as one table using cross table concept and similarly have also created a separate table for months that come under AOP as shown below.

Forecast:

CrossTable(FTO_Date, Data, 1)

LOAD [Action No],

     [F/T/O 01/2017],

     [F/T/O 02/2017],

     [F/T/O 03/2017],

     [F/T/O 04/2017],

     [F/T/O 05/2017],

     [F/T/O 06/2017],

     [F/T/O 07/2017],

     [F/T/O 08/2017],

     [F/T/O 09/2017],

     [F/T/O 10/2017],

     [F/T/O 11/2017],

     [F/T/O 12/2017]

FROM

...

AOP_Targets:

CrossTable(AOP_Target_Date, AOP_Targets_Data, 1)

LOAD [Action No],

[AOP 01/2017],

     [AOP 02/2017],

     [AOP 03/2017],

     [AOP 04/2017],

     [AOP 05/2017],

     [AOP 06/2017],

     [AOP 07/2017],

     [AOP 08/2017],

     [AOP 09/2017],

     [AOP 10/2017],

     [AOP 11/2017],

     [AOP 12/2017]

FROM

...

Any suggestions on this?

Thank you.

3 Replies
el_aprendiz111
Specialist
Specialist

Hi,

Sample in Excel

settu_periasamy
Master III
Master III

Hi,

Have you tried with Combo Chart (Hope two tables are getting related)..?

apoorvasd
Creator II
Creator II
Author

Yes, the two tables are related