topic Re: Real Time solution ? in QlikView

Real Time solution ?

Fri, 05 Jun 2015 16:52:00 GMT

lets assume a I have a database table which is populated with some kind of data and is purged at regular intervals and new data keeps coming in---this is a cycle. Now my qlikview application is just a straight representation of whats present in the table. At any instant of time when I open the qlikview application- it should show the data present in the table at the instant I opened it. I want this to happen without any "button to reload" or server scheduling or anything of that sort.

Just when the user opens the qvw, it should get refreshed/reloaded automatically and show the live data present in the underlying table at that instant. Is this possible ?

Will Direct discovery help here?(Im aware that there is direct query, measures and when u select a dimension..measures get aggregated instantaneouslyin the database blah blah...this is not my usecase as you can see above)

Re: Real Time solution ?

petter — Fri, 05 Jun 2015 17:01:38 GMT

You don't have to have a lot of dimensions in your Direct Discovery - that way it could be suitable for your case. Direct Discovery is the closest thing you get - but it is not real-time.

Why do you want to have data into QlikView without connecting it to anything? It is much better to make a quick Web-App front-end against the database and then rather do an inclusion of this by using the Web Page Viewer Extension to pull it into a QlikView app.

Re: Real Time solution ?

Fri, 05 Jun 2015 19:02:59 GMT

Thanks for your thoughts Petter.

Actually, my underlying tables are kind of a monitoring tables -so they keep getting populated and purged on a continous basis. So however, less reload schedule I place the application on(lets assume 5 mins)- chances are I could miss displaying some of the data.

Therefore, I want to establish kind of a "live link" wherein, when the user opens the application, it would automatically hit the database tables and fetch live data into the dashboard. I want this process to be automatic without anything like buttons-triggers-reload mechanisms. I was thinking if its possible by direct discovery......but that seems to be impossible. hope I was able to explain the scenario clearly...any suggestion other than extensions ?

Re: Real Time solution ?

Tue, 07 Jul 2015 17:41:02 GMT

Couldn't be achieved...I achieved the functionality i desired via a button that triggered a direct discovery refresh...simulating a real time data solution on demand, though