Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

agigliotti
Not applicable

Real time analysis with Qlikview

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

Tags (1)
6 Replies
puttemans
Not applicable

Re: Real time analysis with Qlikview

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
Not applicable

Re: Real time analysis with Qlikview

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
Not applicable

Re: Real time analysis with Qlikview

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
Not applicable

Re: Real time analysis with Qlikview

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
Not applicable

Re: Real time analysis with Qlikview

Currently they are using AJAX client.

barytonsaxen_se
Not applicable

Re: Real time analysis with Qlikview

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.