Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fabio_vallone
Creator
Creator

change Tabs by seconds

Hi,

Is there a way to change automatically the tabs in a QVW, for example, each 30 seconds? thanks.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See here or here or here. The first link is probably the best option.


talk is cheap, supply exceeds demand

View solution in original post

11 Replies
Gysbert_Wassenaar

See here or here or here. The first link is probably the best option.


talk is cheap, supply exceeds demand
fabio_vallone
Creator
Creator
Author

Thanks!

Not applicable

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

fabio_vallone
Creator
Creator
Author

Ok, I'll try.

Thanks!

Not applicable

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!

sandeepprasad_j
Creator
Creator

HI Grape ,

How to stop or cloase the document..

I had used ur script and is working well but how to stop.

Thanks,

Sandeep

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

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

http://www.quickintelligence.co.uk/qlikview-blog/

Not applicable

hit escape ?

sandeepprasad_j
Creator
Creator

HI Yadurand,

Not working da.

Sandeep