topic Re: Access Point refresh automatically after QVW reload? in QlikView

Access Point refresh automatically after QVW reload?

Tue, 22 Apr 2014 22:32:17 GMT

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!

Re: Access Point refresh automatically after QVW reload?

swuehl — Wed, 23 Apr 2014 17:37:57 GMT

Christiani,

maybe this is of help:

QVW's on the Access Point

Re: Access Point refresh automatically after QVW reload?

its_anandrjs — Wed, 23 Apr 2014 17:42:47 GMT

Always check last updated and reload time of the application then you get the information that application is reload or not like.

In any text box write

='Last Update at '&ReloadTime()

Re: Access Point refresh automatically after QVW reload?

maxgro — Wed, 23 Apr 2014 17:45:45 GMT

there is a flag in QMC,

System --> Setup --> Qlikview ServerS --> choose your server --> Document

see below for description

I don't know if, when checked, the reload is immediate or only after the user click (no useful in your case); try and let we know.

Allow Only One Copy of Document in Memory

If there are changes to a document, for example, a reload or a layout change, the QVS can be configured to do either of the following options.

Force an immediate update of the document for the user during the session, that is, allowing only oneversion of a document. This will conserve memory resources on the QVS.
Await a new session, then update the document for the user. This may cause several copies of different versions of the document, residing in memory at the same time.

To allow only one version of the document in memory, tick this check box. To allow several versions of the document in memory, untick this check box.

Re: Access Point refresh automatically after QVW reload?

whiteline — Wed, 23 Apr 2014 18:09:03 GMT

Hi.

Even if the document has been reloaded and updated in memory, I guess, some action should happened the views to be refreshed.

Usually the user makes a selection or something and then see the update.

Try to create some automation activity with the macro.

Upd:

Here are some useful threads.

Seems there are two ways: IE Plugin with properly configured Server and AJAX with modified opendoc template:

Auto refresh of Qlikview document in Browser

Refresh data without user interaction on AJAX client

Re: Access Point refresh automatically after QVW reload?

Wed, 23 Apr 2014 18:35:47 GMT

I don't have access to QEMC since "IT" controls it at my company but I will try this suggestion and post the answer here. It might take a few days to test this.

Re: Re: Access Point refresh automatically after QVW reload?

fkeuroglian — Wed, 23 Apr 2014 21:25:50 GMT

try to change in the document properties/server this option

i attached an example

Good luck

Fernando

Re: Access Point refresh automatically after QVW reload?

busilacchi — Fri, 15 Aug 2014 11:49:29 GMT

Hello there! Very good question Christiani.

I could never solve this problem. The option that says Fernando Keuroglian I never worked !!!

Someone will automatically update the application on the access point without user intervention ???

Thank you very much!

Re: Access Point refresh automatically after QVW reload?

giakoum — Fri, 15 Aug 2014 11:58:10 GMT

I know this is a terrible way to do it, but it is a solution

How to Auto Refresh Pages in Chrome, Firefox and Opera

Re: Access Point refresh automatically after QVW reload?

giakoum — Fri, 15 Aug 2014 13:27:01 GMT

maybe this can help. It is causing an update :

SlideShow.qvw

Re: Access Point refresh automatically after QVW reload?

mvanlutterveld — Fri, 15 Aug 2014 13:43:08 GMT

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

Re: Access Point refresh automatically after QVW reload?

flipside — Fri, 15 Aug 2014 14:20:03 GMT

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>

</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.

Re: Access Point refresh automatically after QVW reload?

rustyfishbones — Thu, 18 Aug 2016 12:28:00 GMT

This is not a bad solution!

Re: Access Point refresh automatically after QVW reload?

Mon, 22 Aug 2016 14:11:40 GMT

Thanks. this works just perfect.

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

Re: Access Point refresh automatically after QVW reload?

Mon, 22 Aug 2016 19:56:29 GMT

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 scroll through differ…

It wors perfect

Thanks

Re: Access Point refresh automatically after QVW reload?

Anonymous — Thu, 17 Nov 2016 16:33:03 GMT

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