Real time analysis with Qlikview

[agigliotti]

Hello,

What about the possibility to make analysis using QVD data with real time data in a single QVW document ?

Should I use direct discovery ?

Please guide me to the right direction to achieve it.

Many thanks in advance.

Best Regards

Andrea

[puttemans]

Hi Andrea,

In the QV management console, you can have a continuous reload of your application. If you connect the application with the updated source, this should be doable. However, I guess once you open the application, the update process for that open application would possibly stop. That's to check.

Regards,

Johan

[petter]

Please define real time....

Real time is probably not the right word for it. In the best of cases you can maybe get close to "near real-time". Using QVD's or Direct Discovery is never real time.

Direct Discovery could be a good solution but it depends on whether you can live with the restrictions it puts on your analysis. For instance you can't use Set Expressions (popularly referred to as Set Analysis) with a DD source.

QVD's are much less close to anything real-time. But you could depending on the way and the volume you extract get it down to a few minutes or even minute level of refresh. Usually you would limit it to every hour or half-hour. An often recurring reload partial or full might disrupt the normal work-flow for your users if it is not crafted carefully.

[agigliotti]

My needed is display flights information for an airport in "real time".

The flights data are stored in a oracle database.

I taked a look at Direct Discovery feature because It refresh the web page with data after a time in seconds you can specify in the script (SET DirectCacheSeconds = XX).

[petter]

The SET DirectCacheSeconds=XX will NOT automatically refresh the client at given intervals. You have to do additional things to get that to happen. What you will have to do depends on which QlikView client you have for your QlikView users. Is it IE Plug-in or the full-browser Ajax?

[agigliotti]

Currently they are using AJAX client.

[Anonymous]

You can use Direct Discovery and let the web browser refresh the page. DirectCacheSeconds must be set lower than the wanted refresh-rate to get updated values.