Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am Looking for a macro that will allow the switching of Tabs in the model every 150 seconds?
Anyone. Thanks
Fabio,
You shouldn't need a macro.
To get you started:
Create a new Variable (v_Timer) withteh following expresion:
=if(mod(minute(now()),2)=0,1,0)
Then under the Conditional show of Sheet1 enter =v_Timer=1 and Sheet2 =v_Timer=0.
In this case your tabs will switch every minute but it's easy to build from there and alter the variable expresion.
I'd also remove the tabrow to make the application look cleaner...and embeded the whole thing in a PowerPoint presentation via the QVX connector which is ideal for display screens.
Hope that helps,
Matt - Visual Analytics Ltd
New Qlikview Design Blog: QVDesign.wordpress.com
Fabio,
You shouldn't need a macro.
To get you started:
Create a new Variable (v_Timer) withteh following expresion:
=if(mod(minute(now()),2)=0,1,0)
Then under the Conditional show of Sheet1 enter =v_Timer=1 and Sheet2 =v_Timer=0.
In this case your tabs will switch every minute but it's easy to build from there and alter the variable expresion.
I'd also remove the tabrow to make the application look cleaner...and embeded the whole thing in a PowerPoint presentation via the QVX connector which is ideal for display screens.
Hope that helps,
Matt - Visual Analytics Ltd
New Qlikview Design Blog: QVDesign.wordpress.com