Qliksense Dashboard LIVE - the app has to refresh based on SQL Query clicking the refresh button

SK28 — Thu, 09 Jun 2022 11:54:00 GMT

Hi,

Is there a way to create the live dashboard in Qliksense?

The dashboard depends on SQL query.

If yes, Can you please share me the template app here? or the solution for it.

Thanks in advance.

Re: Qliksense Dashboard LIVE - the app has to refresh based on SQL Query clicking the refresh button

stevedark — Sun, 12 Jun 2022 18:13:41 GMT

Hi @SK28

Typically a Sense dashboard will have a reload that will happen on a schedule or from a user clicking. You can make those loads frequent and quick by doing a thing called a partial load or an incremental load. This post talks about incremental loads: https://www.quickintelligence.co.uk/qlikview-incremental-load/ (it references QlikView, but the process is identical with Sense).

You can allow a user to do a refresh as required by adding a button and setting an action on that to trigger a reload.

There is also a tech called Direct Query that you can use with Sense dashboards, which will get fresh SQL data as an object in Sense is rendered - but this is more about having a drill to detail rather than having an app which keeps itself permanently refreshed.

Hope that helps.

Steve

topic Re: Qliksense Dashboard LIVE - the app has to refresh based on SQL Query clicking the refresh button in App Development

Qliksense Dashboard LIVE - the app has to refresh based on SQL Query clicking the refresh button

Re: Qliksense Dashboard LIVE - the app has to refresh based on SQL Query clicking the refresh button