Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
skkrishna
Contributor III
Contributor III

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

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.

 

Labels (2)
1 Solution

Accepted Solutions
stevedark
MVP
MVP

Hi @skkrishna 

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

View solution in original post

1 Reply
stevedark
MVP
MVP

Hi @skkrishna 

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