topic Re: Auto-Advance Tabs (on timer) in QlikView

Auto-Advance Tabs (on timer)

andyquirin — Thu, 31 Oct 2013 19:21:30 GMT

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!

Re: Auto-Advance Tabs (on timer)

wms_manis — Thu, 31 Oct 2013 19:54:21 GMT

I have done this before using a combination of variable and conditional shows on the tabs.

Define the variable:

vModTime=mod(Minute(now()),4)

Every Minute the value changes and then use conditional shows on each tab.

=$(vModTimer)=0

=$(vModTimer)=1

=$(vModTimer)=2

=$(vModTimer)=3

Give that a try.

Wade

www.serviambi.com

Re: Auto-Advance Tabs (on timer)

rustyfishbones — Thu, 31 Oct 2013 20:33:05 GMT

Hi Andy,

Do like what Wade says above, however to test it's what you want, change the Variable to

vModTime=mod(Second(now()),4)

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)

HTH

Re: Auto-Advance Tabs (on timer)

rustyfishbones — Thu, 31 Oct 2013 20:37:54 GMT

Note: using functions with NOW() etc... can slow down the App and use up valuable RAM

Re: Auto-Advance Tabs (on timer)

wms_manis — Thu, 31 Oct 2013 20:43:00 GMT

I agree and almost stated that now() can be a memory hog and create performance issues. However, for unattended interaction, it may not hurt too.

Re: Auto-Advance Tabs (on timer)

rustyfishbones — Thu, 31 Oct 2013 20:54:12 GMT

I agree with you too, if not interacted it should be fine

Re: Auto-Advance Tabs (on timer)

andyquirin — Thu, 07 Nov 2013 23:08:58 GMT

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?

Best,

Andy

Re: Auto-Advance Tabs (on timer)

Thu, 07 Nov 2013 23:19:11 GMT

What type Pulgin you are using ?

The now() function won't call every second on the AJAX Client

Re: Auto-Advance Tabs (on timer)

andyquirin — Fri, 08 Nov 2013 15:12:09 GMT

IE works - thank you sir!

Re: Auto-Advance Tabs (on timer)

andyquirin — Tue, 03 Dec 2013 18:15:36 GMT

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? Wade Manis @Alan Farrel

Re: Auto-Advance Tabs (on timer)

stevedark — Sat, 18 Jan 2014 22:18:34 GMT

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/

Re: Auto-Advance Tabs (on timer)

simonb2013 — Wed, 16 Mar 2016 12:51:20 GMT

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.