topic Re: Webpage refresh WITHOUT mouseclick in Ajax client in QlikView

Webpage refresh WITHOUT mouseclick in Ajax client

Thu, 21 Feb 2013 08:50:53 GMT

Hi,

We are about to set up a dashboard on a "public" monitor. We want the dashboard to be on a timer, so at second X it switches sheets. On the forums

we have found various scripts that helps us do that. The problem is that the scripts found only work with the IE plugin, and not in the Ajax client, which we are bound to use. The Ajax client only updates the timer (and switch sheets) IF someone nudges the application with a mouse click.

This is the script we are currently experimenting with:

[Timing]:

LOAD

recno() as Tab

,rangesum(Seconds,peek(Seconds)) as Seconds

INLINE [

Seconds

];

[Show]:

LOAD

'=' & concat('if(vSeconds<' & Seconds & ',' & Tab,'

,') & repeat(')',max(Tab)) as Show

,'=mod(round((now()-now(2))*86400),' & max(Seconds) & ')' as Seconds

RESIDENT Timing;

LET vShow = peek('Show');

LET vSeconds = peek('Seconds');

DROP TABLES [Show], [Timing];

We have also tried this one:

Set vDelay = 15; // duration of screen in seconds

Set vSheets = 10; // number of sheets

Set vShow = =ceil((frac(now())*86400/(vSheets*vDelay)-floor(frac(now())*86400/(vSheets*vDelay)))*(vSheets));

...and some others.

To conclude: the problem is not that data need to be reloaded, just that the visualisation needs to be refreshed at given intervals. We will not be able to man the client with a mouseclicker-person

Is there anyway to solve this? I have searched the forums and seen a lot of people with this issue, but have not yet found a solution. (For now, we are thinking about using an extension to Chrome that enables webpage refresh at intervals. However, this is not a sustainable solution.)

Please ask me questions if I need to clarify anything. Thank you so much for your help!

Re: Webpage refresh WITHOUT mouseclick in Ajax client

Thu, 21 Feb 2013 09:00:01 GMT

Oh, yeah, we are using QV 11.

Re: Webpage refresh WITHOUT mouseclick in Ajax client

Thu, 21 Feb 2013 09:32:38 GMT

Thank you, but this solution does not switch sheets until a user clicks at the application. Is there anyway to simulate a mouseclick or other user interaction?

(In Ajax, with IE plugin this solution runs like a charm)

Re: Webpage refresh WITHOUT mouseclick in Ajax client

Mon, 04 Mar 2013 14:21:37 GMT

Anyone?

Closest we got so far is to use http://www.urlreload.com/ or similar.

Edit: Is it possible to somehow apply HTML-code to QV-apps? That way we could insert a script for automatic refresh/reload.

Message was edited by: philip.sjokvist2

Re: Webpage refresh WITHOUT mouseclick in Ajax client

fosuzuki — Mon, 04 Mar 2013 18:25:11 GMT

I never needed that, but I suppose you can do it two ways:

1. document extension.

2. hack the opendoc.htm file.

Hope this helps you

Fernando

Re: Webpage refresh WITHOUT mouseclick in Ajax client

Tue, 05 Mar 2013 09:53:01 GMT

Thank you for your answer!

Hacking the opendoc.htm file is probably not an option.

I am however interested in the document extension-option. Do you have any idea as to what extension would be used (if there is an existing one for applying html-code to QV-apps) and how we would go about it?

Re: Webpage refresh WITHOUT mouseclick in Ajax client

Wed, 11 Sep 2013 06:55:13 GMT

Try this if it work for you http://community.qlik.com/docs/DOC-4752, Regards.

Re: Webpage refresh WITHOUT mouseclick in Ajax client

Stefan_Walther — Tue, 26 Nov 2013 17:27:01 GMT

Here's a document extension which exactly does what you are trying to achieve: http://www.qlikblog.at/2779/qlikview-autorefresh-document-extension/

Regards

Stefan

Re: Webpage refresh WITHOUT mouseclick in Ajax client

Anonymous — Tue, 26 Nov 2013 21:07:20 GMT

Philip

If it is just one 'public monitor' why not use IE & the plugin, it is dead easy that way. Whoever stipulated Aja only could agree to that if it is just one monitor for a specific reason.

You never know in the QlikView.Next there may well be an easy way do it without the IE Plugin.

Best Regards, Bill

Re: Webpage refresh WITHOUT mouseclick in Ajax client

Anonymous — Tue, 03 Dec 2013 05:22:52 GMT

Hi Philip,

Have you find the solution for your query,

If I am getting it correct, you just need to activate different sheets at some specifiive time interval, irrespective of any compatibility with browsers.

You can use show/hide functionality on sheet level for particular time intervals.

Thanks

Nitin Gupta