Graphing capabilities

[#1]

I am very new to QlikView and in the process of evaluating its capabilities.

Some brief background of our situation and desires

We have a database that collects performance data from our cancer treatment machines on a more or less continuous basis. We would like to be able to chart some of these parameters against time and then zoom into areas that show anomalies and then add parameters to the existing chart or add charts with new parameters for the same time period.

As an example I am trying this with 2 parameters against time:

Samples of the two tables I am using are below, the first is a doserate, the second is a parameter that can affect doserate.. QlikView sets up a relation with time as the key but I cannot find a way to make QlikView draw a graph of doserate against time without any aggregation or expressions. .

Any suggestions gratefully received

Doserate	Time
0	08/03/2010 07:15:09
13	08/03/2010 07:19:50
419	08/03/2010 07:19:51
422	08/03/2010 07:19:52
420	08/03/2010 07:19:53
417	08/03/2010 07:19:54
414	08/03/2010 07:19:55
406	08/03/2010 07:19:56
405	08/03/2010 07:19:57
400	08/03/2010 07:19:58
394	08/03/2010 07:19:59
391	08/03/2010 07:20:00
385	08/03/2010 07:20:01
384	08/03/2010 07:20:02
381	08/03/2010 07:20:03
379	08/03/2010 07:20:04
0	08/03/2010 07:20:05
44	08/03/2010 07:20:17
371	08/03/2010 07:20:18
364	08/03/2010 07:20:19
363	08/03/2010 07:20:20

2RI	Time
34	08/03/2010 07:06:28
0	08/03/2010 07:11:13
34	08/03/2010 07:15:09
38	08/03/2010 07:16:42
43	08/03/2010 07:16:45
50	08/03/2010 07:16:48
58	08/03/2010 07:16:50
53	08/03/2010 07:16:53
50	08/03/2010 07:17:00
43	08/03/2010 07:17:03
38	08/03/2010 07:17:05
34	08/03/2010 07:17:12
14	08/03/2010 07:18:54
13	08/03/2010 07:19:51
12	08/03/2010 07:19:52
5	08/03/2010 07:19:53

[#2]

Keith,

If you could upload a QVW file with a sample of your data, it would help. Thanks!

[#3]

Hello Jason (and others)

I have atached a file that I started last week.

There are 4 tables of data all keyed on time. The doserate is an output from our machine which can operate at several different energies, listed in the energy table. The 2RI table contains values of a parameter that can have an effect on the doserate.

The ideal operation is a jump from 0 doserate to the operating level in less than 2 seconds followed by a period of operation at a constant doserate. If the doserate is not constant I would like to be able to select the period of time during which it is changing and then look at other parameters, such as 2RI, to see if I can correlate the doserate variation to one of the operating parameters.

To facilitate this I would like to be able to just plot in the first instance doserate against time without any aggregation.

Thanks for looking.

Keith