topic Re: Real time analysis with Qlikview in QlikView

Real time analysis with Qlikview

agigliotti — Wed, 02 Mar 2016 14:14:46 GMT

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

Re: Real time analysis with Qlikview

puttemans — Wed, 02 Mar 2016 14:25:59 GMT

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

Re: Real time analysis with Qlikview

petter — Wed, 02 Mar 2016 14:26:10 GMT

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.

Re: Real time analysis with Qlikview

agigliotti — Wed, 02 Mar 2016 14:54:26 GMT

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).

Re: Real time analysis with Qlikview

petter — Wed, 02 Mar 2016 15:38:00 GMT

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?

Re: Real time analysis with Qlikview

agigliotti — Wed, 02 Mar 2016 15:44:10 GMT

Currently they are using AJAX client.

Re: Real time analysis with Qlikview

Anonymous — Tue, 05 Jul 2016 08:37:30 GMT

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.