Pie Chart Using Set Parameters

Tue, 02 Jun 2015 15:18:28 GMT

Hi,

(I realise the below is quite complicated, but any help would be really appreciated!)

With the below tables, is it possible to create a pie chart that has the list of Runs in the 'Actual Runs' table, in the following segments:

GREEN - Actual Start Time is within 5 minutes of the Scheduled Start Time

AMBER - Actual Start Time is between 5 and 15 minutes of the Scheduled Start Time

RED - Actual Start Time is more than 15 minutes of the Scheduled Start Time

So in this example, by selecting Run1, we would see the chart split three ways, with: 1 green, 1 amber, 1 red. Run6 and Run7 would also not be selectable as they are not in the 'Scheduled Runs' table.

The format for the Time is as follows:

Start/End Time: HHMMSS

155712 = 15:57:12

1533 = 00:15:33

424 = 00:04:24

Scheduled Runs

Name	Description	Scheduled Start Time	Scheduled End Time
Run1	ABC	153000	153005
Run2	123	235500	500
Run3	XYZ	900	1500
Run4	456	83000	83500

Actual Runs

Name	Status	Actual Start Time	Actual End Time
Run1	C	152712	152911
Run1	C	153634	153728
Run1	F	155034	155324
Run2	F	235621	424
Run2	C	1533	1756
Run6	C	210002	210342
Run7	C	5626	10126

Thanks and kind regards,

Tristan

topic Pie Chart Using Set Parameters in QlikView

Pie Chart Using Set Parameters