I have done this before using a combination of variable and conditional shows on the tabs.
Define the variable:
Every Minute the value changes and then use conditional shows on each tab.
Give that a try.
ScreenScrollExample.qvw 328.0 K
Do like what Wade says above, however to test it's what you want, change the Variable to
It will change every second, it will save you waiting a minute for each to change
and then if you are happy that's what you need, change the variable back to mod(Minute(Now()),4)
Hey Alan and Wade,
I just implemented your suggestions and I feel I'm 95% of the way there.
I pushed the dash to test (with the variable timer set to seconds) to see how it worked. I'm noticing the dash is only advances when it's clicked on and isn't advancing automatically.
Did you guys run into the same issue? Is there something I'm overlooking so the conditional tabs are calculated on the fly and don't wait for someone to click the dash for it to advance?
Part II of our Auto-Advance adventure:
I got the requirement to work by using a variable vModTime=mod(Minute(now()),10)+1 where 10 is the number of slides that I have. I couple this with a document Trigger, under Variable Event Triggers 'OnChange' ='Document\SH0'&vModTime.
This advances to the next slide when the minute changes.
Here's the trick - I've been asked to speed it up so it advances every 30 seconds.
How would you do it for 10 slides? If I used vModTime=mod(second(now()),x)+1, x can only be a max of 60...
Any help? wms_manis @Alan Farrel
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:
<meta http-equiv="refresh" content="60; url=frame2.html">
<iframe id="qvdemo" style="border: none;" name="qvdemo" src="http://ServerName/QvAjaxZfc/opendoc.htm?document=System/QlikView%20Status%20Dashboard.qvw&host=localhost&select=TRIGGER,0&sheet=OVIEW" width="100%" height="100%"></iframe>
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.
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.