Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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.
This is not a bad solution!
Thanks. this works just perfect.
Does anyone knows if there is a way to do the same for Qlik Sense?
Ready...
For Sense you just need to use this extension
It wors perfect
Thanks
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