topic Re: automatically move to next sheet within interval time in QlikView

automatically move to next sheet within interval time

Tue, 26 Jul 2011 03:25:46 GMT

how to create an automatically function to move to next sheet within interval time, eg. every 15 minutes will move to next sheet, without any click on button.

is there anyone who can help me on this?? please...

Re: automatically move to next sheet within interval time

Tue, 26 Jul 2011 12:08:33 GMT

Hi,

PFA. This is just a test app created with some stuff pending. The variable var1 needs to be reset to current time value somehow on the last sheet before moving to the Main sheet, I'm kindoff stuckup there. Experts kindly suggest how to reset a variables value using trigger actions at sheet or document level. The show sheet on a specific condition is utilized here. Also,currently,the value(interval time) is directly added to the minute part of timestamp, in the condition specified(proper addition using DateTime functions should be done). Just open the document and after every minute the next sheet will be shown.(Note: It works only for first loop coz of reason mentioned above). Triggers have been utilized to set the variable value.

Thanks.

automatically move to next sheet within interval time

Thu, 04 Aug 2011 17:03:31 GMT

Thanks lawrence, for your feedback. At least giving me some idea but as you said, still struggle with the variable.

automatically move to next sheet within interval time

Thu, 04 Aug 2011 18:03:28 GMT

Try something like this:

Set a variable up like this: which should be the minute times the number of seconds / 900 and if the remainder of that is zero it returns 1

=if(mod(minute(localTime()) * second(localTime()),900) = 0,1,0)

Then set up a trigger for on change for the variable you just created to run a macro that actives the next sheet, which shouldn't be too hard (although I hav no clue how to do it off the top of my head). Note that if you do the on change trigger it's going to switch twice... so you'll have to fix that somehow.

Not sure if that will work but something like that probably will. Note that my QV is getting errors like crazy using that probably b/c it gets the time every second... but maybe you'll have better luck.

Hopefully something I said helps b/c I'm certain my solution won't work as is.

Re: automatically move to next sheet within interval time

johnw — Thu, 04 Aug 2011 19:12:04 GMT

In the first attached file, only one tab is visible at a time (you would probably hide the tabrow in practice), and an inline table sets how many seconds should be spent on each tab. The second file is a minor tweak that keeps all three tabs visible, and just switches tabs. The conditional show for each tab as been removed. Instead, we have a variable event trigger on change of the vShow variable. It uses a pick(vShow,'SH03','SH04','SH05') to select the right tab.

Hmmm, in my old QV version at least, the second one doesn't seem to count the seconds until you "nudge" QlikView by clicking on one of the other tabs. Strange.

automatically move to next sheet within interval time

Thu, 04 Aug 2011 19:35:52 GMT

Dear John, thank you for your answer. The first file is good for me to start a "cockpit" coz we have 6 big screen for management in 1 room.

Will try to maximize your file again to suit my needs.

automatically move to next sheet within interval time

Wed, 21 Sep 2011 10:35:31 GMT

Its Not working in Ajax and web layout.

Can you please help me out in this

automatically move to next sheet within interval time

Thu, 29 Sep 2011 23:49:39 GMT

it's working..but using ie plugin in ie

Re: automatically move to next sheet within interval time

Fri, 27 Jul 2012 11:23:02 GMT

Hi,

Can we make automatically move to another sheet object in container without user interaction ?

And In my container object contains "Animate objects" are presented, now after fist animate object completes then should move to second animte object and then should move to third object, after all objects are completed then stay at first animate object.

Is this possible ? Please find the attached app.

Thanks in advance.

Regards,

Venkat

Re: automatically move to next sheet within interval time

Wed, 14 Nov 2012 16:51:06 GMT

All,

I'm unable to get the ajax client to auto switch the tabs. It works fine in the desktop client but the browser (Chrome, Safari, IE) does not work. If I continue to click on the page, it seems to count down and switch. Any ideas?

Re: automatically move to next sheet within interval time

Wed, 26 Dec 2012 20:37:10 GMT

I´m having the same problem.

Any solution?

Re: automatically move to next sheet within interval time

Karthik3 — Tue, 25 Oct 2016 15:18:21 GMT

For timing we could just use TIMESTAMP(now(), 'ss')

Re: automatically move to next sheet within interval time

ccsimo16 — Sat, 22 Jul 2017 11:16:00 GMT

Did anyone manage to the the sheet switching in Chrome? My app switches once, but then stays on the second tab. If it's in Qlikview app it works fine.

Thanks

Chris

Re: automatically move to next sheet within interval time

nizarch13 — Wed, 09 Aug 2017 07:25:28 GMT

Thanks John,

Really Helpful

Regards Nizar

Re: automatically move to next sheet within interval time

waszcma1 — Thu, 11 Jan 2018 21:16:06 GMT

I still facing with some problem

i have 3 tabs switchable every 10 seconds but each page should have they own selections so I use triggers OnActivateSheet - >Select in Field [for example for month - month(now())]

but the problem is that those pages are not activated but only hidden so when vShow is 1 is still not triggering the right selections.

I am quite poor in macro - but is it the only way to activate the visible sheet ?