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

[SK28]

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.

[stevedark · Accepted solution]

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