Automatic switching of sheets

[#1]

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?

[Oleg_Troyansky · Accepted solution]

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.

[#3]

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.....

[#4]

Hi ,

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

Cheers,

Bhushan N

[#5]

That is absolutely fantastic, Thank you very much

[#6]

Thanks Bhushan that is great

[#7]

Can you please update the VBA script for the same.

[#8]

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

[#9]

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

[#10]

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.