Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

error loading image

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_IDTIMESTAMPVALUE
C2011-02-16 09:00:011
A2011-02-16 09:00:2212,44999981
B2011-02-16 09:00:55220
A2011-02-16 09:01:2213,44999981
B2011-02-16 09:01:25134
B2011-02-16 09:01:5599
C2011-02-16 09:02:221
B2011-02-16 09:02:2557
A2011-02-16 09:02:3114,60000038
C2011-02-16 09:02:310
B2011-02-16 09:02:5566
B2011-02-16 09:03:2575
A2011-02-16 09:03:3115,61666679
B2011-02-16 09:03:5584
C2011-02-16 09:04:110
B2011-02-16 09:04:2593
A2011-02-16 09:04:3116,61666679
C2011-02-16 09:04:311
B2011-02-16 09:04:56102
B2011-02-16 09:05:25111
A2011-02-16 09:05:3217,61666679
B2011-02-16 09:05:55120
C2011-02-16 09:06:380
C2011-02-16 09:07:381

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)

0 Replies