Loading a user selected number of datasets from the same datasource into chart as separate expressions?
Loading a user selected number of datasets from the same datasource into chart as separate expressions?
I am currently evaluating QlikView for using it together with an industrial automation system that saves large amount of process data into an Oracle database.
After tinkering with the Desktop Personal version for a couple of days, I have become stuck and would really appreciate if anyone can point me in the right direction or at least tell me if it possible to do the following in Qlikview.
What we what The system collects analog and digital data from a huge number of sensors and we need an application where a user can select an unknown number of sensors and display their respective timestamped data in a chart(line/scatter) object for a selected timeperiod.
Example Concept Sketch
The data source. It´s an Oracle database and there is unfortunately no way to alter how the system stores the data in it - and how it stores the data is probably the thing that makes this a bit of a challenge. Analog and digital data is collected from a huge number of sensors and saved with an ID and timestamp in a huge table. The amount of data grows quite fast, we are talking about millions of new records every day so it is absolutely neccessary to load only a subset of the data when required.
Example data.
SENSOR_ID
TIMESTAMP
VALUE
C
2011-02-16 09:00:01
1
A
2011-02-16 09:00:22
12,44999981
B
2011-02-16 09:00:55
220
A
2011-02-16 09:01:22
13,44999981
B
2011-02-16 09:01:25
134
B
2011-02-16 09:01:55
99
C
2011-02-16 09:02:22
1
B
2011-02-16 09:02:25
57
A
2011-02-16 09:02:31
14,60000038
C
2011-02-16 09:02:31
0
B
2011-02-16 09:02:55
66
B
2011-02-16 09:03:25
75
A
2011-02-16 09:03:31
15,61666679
B
2011-02-16 09:03:55
84
C
2011-02-16 09:04:11
0
B
2011-02-16 09:04:25
93
A
2011-02-16 09:04:31
16,61666679
C
2011-02-16 09:04:31
1
B
2011-02-16 09:04:56
102
B
2011-02-16 09:05:25
111
A
2011-02-16 09:05:32
17,61666679
B
2011-02-16 09:05:55
120
C
2011-02-16 09:06:38
0
C
2011-02-16 09:07:38
1
The real data source carries tens of thousands sensors.
What I have achieved so far with Qlikview Making a sheet displaying one selected sensor for a selected timeperiod is easy. The problem comes with loading more than one sensor into the same chart and especially when the number of sensors are to be determined in runtime .
The question?
Is this possible to achive with Qlikview?
Can one write an expression that returns an entire dataset?(and then use it with AddExpression)