Solved: Auto-Advance Tabs (on timer) - Page 2 - Qlik Community

andyquirin · ‎2013-10-31

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!

stevedark · ‎2014-01-18

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>

</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 · ‎2016-03-16

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.