Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
devarasu07
Master II
Master II

Qliksense Dashboard LIVE - Real time

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

Labels (1)
10 Replies
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.


talk is cheap, supply exceeds demand
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
Contributor II
Contributor II

Hi!

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

morenoju
Partner
Partner

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
Partner
Partner

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

Brendan
Partner
Partner

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
Partner
Partner

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. 

@mtarallo , 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
Partner
Partner

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?