Webpage refresh WITHOUT mouseclick in Ajax client

[#1]

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

20

10

5

];

[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!

[#2]

Oh, yeah, we are using QV 11.

[#3]

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)

[#4]

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

[fosuzuki]

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

[#6]

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?

[#7]

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

[Stefan_Walther]

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

[Anonymous]

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

[Anonymous]

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