Qliksense Dashboard LIVE - Real time

[devarasu07]

Hi,

Kindly advise real time dashboard with qliksense.  we wanted to show live summary sales data in real time

i.e,  the dashboard should get updated whenever data is being updated/loaded from Database.for example the dashboard should change frequently based on the incoming data like retail/online sales

Note : without refreshing app via qmc or the webpage refresh using java script or data discovery option) 

Thanks in Advance !

Best Regards

Deva

[Gysbert_Wassenaar]

You could write an application that uses the Qlik Sense api's to reload the dashboard app and monitors the database for changes. That seems to be the only option available to meet your requirements.

[rwunderlich]

Qlik Sense is generally not a good platform for real time reporting/monitoring.  Do you need all the data to be fresh or just a single KPI like total Sales?

-Rob

[feliperesende]

Hi!

Did you get any solution for this problem? I also need it.

[morenoju]

Hi @rwunderlich, for data that has to be fresh (for example, real-time position of millions of vehicles) do you know any good platform for monitoring?

With some aggregations by area, Qlik Sense can be great for historical analysis, but in this case I'm referring to something live.

Thanks

[rwunderlich]

I have not done any real-time projects of the size you propose, perhaps others will chime in.  I imagine a solution would be to use something like kafka or elastic to handle the streaming and a query/dashboard tool on top of that.  Search on something like "kafka dashboards" or "streaming dashboards" to get some ideas.

-Rob

[morenoju]

Thanks for the suggestions @rwunderlich. I'm having a look at the "streaming dashboards". That might be what I'm looking for.

[Brendan]

Hi,

I am curious about this also.

Just wondering if the source transactional tables are updated realtime would you use something like Direct Discovery?

https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/DirectDiscovery/differen...

Thanks

Brendan

[morenoju]

Hi @Brendan, thanks for bringing this thread back to life!

My approach within Qlik Sense would be using dynamic views as featured in this video:

https://www.youtube.com/watch?v=M60l1xjyNI0

However, the manual refresh on demand is not a valid option for me, so I plan to wait for a release that allows to configure an automatic refresh and try real time positions on a map. 

@Anonymous , do you know if the next release of Qlik Sense would allow automatic refresh of dynamic views? Is it realistic to expect being able to refresh a map every 1 or 2 seconds? Or dynamic views are designed to work being refreshed every few minutes?

Thanks

[morenoju]

This is an old thread about real time dashboards and streaming analytics.

Do you guys know if Qlik Sense has started to look into this kind of use cases and/or has something planned in the roadmap?