creating a Diagram

Mon, 05 Oct 2015 06:41:17 GMT

Hello,

i need help for a simple example. There are the following data from different runners. I got a table from each person.

I want to create to diagrams. The first show for all Runners the Number of Runs, the Duration of Runs, the Rank for each discipline. I want to see the average value and the max Value.

The second diagram show the result for each Runner, for each Run.

The timestamp at the x-axis. A bargraph for each run with the Value of the duration and Number of run and rank as labeling of the bar.

Runner 1:

Timestamp	ValueName	Min Value	Max Value	Avg Value
00:00:10:00	Number of 100m-Run		1
00:00:10:00	Duration of 100m-Run		100s
00:00:10:00	Rank of 100m-Run		29
00:00:30:00	Number of 500m-Run		1
00:00:30:00	Duration of 500m-Run		500s
00:00:30:00	Rank of 500m-Run		3
00:00:50:00	Number of 500m-Run		2
00:00:50:00	Duration of 500m-Run		300s
00:00:50:00	Rank of 500m-Run		2
00:01:50:00	Number of 100m-Run		2
00:01:50:00	Duration of 100m-Run		120s
00:01:50:00	Rank of 100m-Run		35
	Number of 100m-Runs	1	2	1,5
	Number of 500m-Runs	1	2	1,5
	Duration of 100m-Runs	100s	120s	110s
	Duration of 500m-Runs	300s	500s	400s
	Rank of 100m-Runs	29	35	32
	Rank of 500m-Runs	2	3	2,5

Runner 2:

Timestamp	ValueName	Min Value	Max Value	Avg Value
00:20:10:00	Number of 100m-Run		1
00:20:10:00	Duration of 100m-Run		80s
00:20:10:00	Rank of 100m-Run		20
00:20:30:00	Number of 500m-Run		1
00:20:30:00	Duration of 500m-Run		400s
00:20:30:00	Rank of 500m-Run		2
00:20:50:00	Number of 500m-Run		2
00:20:50:00	Duration of 500m-Run		300s
00:20:50:00	Rank of 500m-Run		1
00:21:50:00	Number of 100m-Run		2
00:21:50:00	Duration of 100m-Run		100s
00:21:50:00	Rank of 100m-Run		22
	Number of 100m-Runs	1	2	1,5
	Number of 500m-Runs	1	2	1,5
	Duration of 100m-Runs	80s	100s	90s
	Duration of 500m-Runs	300s	400s	350s
	Rank of 100m-Runs	20	22	21
	Rank of 500m-Runs	1	2	1,5

topic creating a Diagram in QlikView

creating a Diagram