topic Re: Automatic switching of sheets in QlikView

Automatic switching of sheets

Mon, 10 May 2010 13:58:07 GMT

I have a Qlikview model that displays information on a plasma screen. Currently this is all available on 1 sheet, but I need to display 1 sheet for say 3 minutes and the switch to 2nd sheet for 3 minutes then back to sheet 1.

Any ideas how this can be automated?

Automatic switching of sheets

Oleg_Troyansky — Mon, 10 May 2010 14:03:50 GMT

Use VBScript macro, and you'll be able to use timer() to control your time-driven logic. The API syntax to activate a sheet is very simple - look it up in the API Guide.

Automatic switching of sheets

Mon, 10 May 2010 14:05:28 GMT

Take a look at the 'now' function which returns the current time; by using the 'minute' function with it you should be able to condition the sheet display.

This may thrash the server though as it will be constantly checking the time.....

Automatic switching of sheets

Tue, 11 May 2010 12:01:36 GMT

Hi ,

Attaching excellent QV doc which i downloaded from Community . It may resolve your problem .

Cheers,

Bhushan N

Automatic switching of sheets

Wed, 12 May 2010 09:41:10 GMT

That is absolutely fantastic, Thank you very much

Automatic switching of sheets

Wed, 12 May 2010 09:42:11 GMT

Thanks Bhushan that is great

Automatic switching of sheets

Wed, 21 Sep 2011 10:53:10 GMT

Can you please update the VBA script for the same.

Re: Automatic switching of sheets

Thu, 03 Jan 2013 09:52:42 GMT

Hi davesargeant,

Please find the below macro:

Sub SwitchTab
For x = 0 to 5
ActiveDocument.ActivateSheet x
ActiveDocument.GetApplication.Sleep 1000
ActiveDocument.GetApplication.WaitForIdle
next
End Sub

Regards,

Snehal Nabar

Re: Automatic switching of sheets

Wed, 14 Aug 2013 15:14:52 GMT

Hi Snehal,

It sound making sense. But way complicated to a newbie like me.

Would u mind to provide a simple sample code?

Appreciate your help very much

Re: Automatic switching of sheets

Tue, 01 Apr 2014 17:03:38 GMT

Is there a way to set this up as a loop?

I have it working but it only switches sheets one time and then stops.

Re: Automatic switching of sheets

Thu, 05 Mar 2015 18:12:00 GMT

I have 3 sheets in my project and i want switch between sheets after 2 second automatically

please send for me an example

Thanks

Re: Automatic switching of sheets

GartoJsar — Mon, 13 Aug 2018 15:52:11 GMT

hello Hossein Ramshini

Exelect example with you APP.

hello Hossein Ramshini

but when you select in web mode your sheets do not change anymore and it is the same thing that happens, do you know if you have to add something so that it also works in web mode?

Thank you