Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andyquirin
Partner - Contributor III
Partner - Contributor III

Auto-Advance Tabs (on timer)

Hey QlikView Community,

I've been asked to put together a dashboard that would be projected on a wall and display a variety of different metrics. It's way to much to put on a single tab, and would have to be broken out into several.


Is there a way for a dashboard to automatically rotate through a series of tabs all day without any human interaction? Basically having 10 tabs that change at 2 minute intervals then return to the first tab at the end.

Any help is much appreciated!! Happy Halloween!

11 Replies
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Andy,

Personally I would be very wary of using the now() statement in a dashboard, as this will interrupt QlikView doing other processing and be a resource hog.  Where I have done an auto advance before I have used a HTML page with the following on it:

<html>

<head>

<meta http-equiv="refresh" content="60; url=frame2.html">

</head>

<body>

<iframe id="qvdemo"  style="border: none;" name="qvdemo" src="http://ServerName/QvAjaxZfc/opendoc.htm?document=System/QlikView%20Status%20Dashboard.qvw&host=local..." width="100%" height="100%"></iframe>

</body>

</body>

</html>

This advances to the next page after 60 seconds, and the browser looks after the timer - so it can not impact on the QlikView server.  There are a number of HTML files each with a different URL in the iFrame - using the sheet parameter to the opendoc file allows for progressing through tabs in a single document - but you could equally go to tabs in different documents this way.

Not sure how you would do the calculation of the duration in an HTML page though - you could do it with ASP but you would have to pass in how many pages it was enumerating.

Hope that helps.


Steve

http://www.quickintelligence.co.uk/

simonb2013
Creator
Creator

I tried similar to this, I needed to change a chart filter on an interval cycle.

Not ideal , as it's refreshing the entire page/document, rather than simply changing a filter (my aim).

Looks dreadful for the user, is slow, and is making the web server do more work that it strictly needs to.

It's a work around at best.

Having said that, I have yet to find a workable alternative.
There is a .Net COM component that in theory could be used to automate a QV doc. but that'a a whole other story.

Given the amount of similar posts I've seen on this subject - would be nice if the QV people just provided this timer functionality out of the box.