Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a way to change automatically the tabs in a QVW, for example, each 30 seconds? thanks.
Thanks!
Hi
I have a macro for this also. Start it by alling the Start sub.
SUB Start
ChangeTabs 3
END SUB
SUB ChangeTabs(intChangeTabsDelay)
' Get number of sheets
intSheets = ActiveDocument.NoOfSheets
' Infinite loop
DO
' Add to sheet counter
intSheet = intSheet + 1
' Check if last sheet is passed
IF intSheet > intSheets - 1 THEN intSheet = 0
' Activate sheet
ActiveDocument.ActivateSheet intSheet
' Wait for application to catch up
ActiveDocument.GetApplication.WaitForIdle
' Wait
ActiveDocument.GetApplication.Sleep intChangeTabsDelay * 1000
' End infinite loop
LOOP UNTIL 1 = 2
END SUB
Cheers
Ok, I'll try.
Thanks!
Hi, i'm new in macros, so I hope someone can guide me.
I want to create a 'dashboard' on my 60' LCD screen, where all values from a field ('Store') are changed every 10 sec. and then looped.
Hope to get some input. Thanks!
HI Grape ,
How to stop or cloase the document..
I had used ur script and is working well but how to stop.
Thanks,
Sandeep
Hi there,
Are there a finite number of values in Store? If so you should be able to adapt the attached code.
This uses standard HTML code to flip between different pages (page one and two are two tabs on the same dashboard, the third is elsewhere). You will see in frame one and two there is a select parameter. I have a listbox called TRIGGER that is being selected (in order to fire an Action on page change). You will need to create a listbox for Store and have a 'frame' for each store entry.
If there are a large number of Stores, or the there is the potential for the list to expand you may need to use another approach - but this should point you in the correct direction.
The code for frame1.html in the attachment is:
<html>
<head>
<meta http-equiv="refresh" content="60; url=frame2.html">
</head>
<body>
<iframe id="qvdemo" name="qvdemo" src="http://server/QvAjaxZfc/opendoc.htm?document=System/QlikView%20Status%20Dashboard.qvw&host=localhost..." width="100%" height="100%"></iframe>
</body>
</html>
Hope that helps you out.
Regards,
Steve
hit escape ?
HI Yadurand,
Not working da.
Sandeep