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