Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Access Point refresh automatically after QVW reload?

I am trying to use Qlikview to display results of a Survey on multiple TV screens, in multiple locations. I have created the QVW that will show survey comments and rotate them after a few seconds. The issue is I need to reload the QVW once a day to get new data. When I do that the new data doesn't show automatically in Access Point. All TV monitors will be showing the Access Point QVW. How can I make sure that after a reload of this QVW all TV screens are showing the new data? This should be done automatically.

Thank you!

15 Replies
mvanlutterveld
Partner - Creator II
Partner - Creator II

Hi Christiani,

In case you’re using the AJAX client Stefan Walther created a neat extension. I’ve used this one in a case similar to yours and it works perfect: http://www.qlikblog.at/2779/qlikview-autorefresh-document-extension/

Cheers,

Michiel

flipside
Partner - Specialist II
Partner - Specialist II

I got a solution working using iframes but this isn't tested fully so guess it will depend on browser and local security policies etc..

Here's the html code with a 60second refresh rate (content) ...

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="refresh" content="60">
<style type="text/css">
html {
overflow:hidden;
}
iframe {
  margin-top: 10px;
  margin-bottom: 10px;
  margin-left: 0px;
  margin-right: 0px;
  height: 800px;
  width: 99%;
  border: 5px #AAAAAA solid;
}

</style>

<title>Qlikview</title>
</head>
<body style="background-color:#CCCC99;color:#666666">

<p>
<script language="JavaScript">
    document.write('Page reloaded at: ' + '<b>' + (new Date).toLocaleString() + '</b>');
</script>
</p>

<iframe
   src="http://<servername>/QvAJAXZfc/opendoc.htm?document=????.qvw&host=?????"
   frameborder="0";>
</iframe>


</body>
</html>

Hope it helps.

EDIT: Forgot to add that you just add this code into a file and save as (for example) PageRefresh.htm and this can be opened in a browser. Works in IE10. Remember to replace the server name, document name and host name for src.

rustyfishbones
Master II
Master II

This is not a bad solution!

Not applicable
Author

Thanks. this works just perfect.

Does anyone knows if there is a way to do the same for Qlik Sense?

Not applicable
Author

Ready...

For Sense you just need to use this extension

GitHub - ardwork/automated-sheet-scroll: A Qlik Sense extension allowing users to set an automated s...

It wors perfect

Thanks

Anonymous
Not applicable
Author

Hi Christiani !

Were you able to refresh the dashboards through access point on multiple TV screens ?

If so could you please fill us in with detailed steps which would be really helpful for newbies like me

Thanks in Advance,

-- Ajay