Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

fabioval
Contributor

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

Re: change Tabs by seconds

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


talk is cheap, supply exceeds demand
11 Replies

Re: change Tabs by seconds

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


talk is cheap, supply exceeds demand
fabioval
Contributor

Re: change Tabs by seconds

Thanks!

Not applicable

Re: change Tabs by seconds

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

fabioval
Contributor

Re: change Tabs by seconds

Ok, I'll try.

Thanks!

Not applicable

Re: change Tabs by seconds

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
Contributor

Re: change Tabs by seconds

HI Grape ,

How to stop or cloase the document..

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

Thanks,

Sandeep

MVP
MVP

Re: change Tabs by seconds

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

Re: change Tabs by seconds

hit escape ?

sandeepprasad_j
Contributor

Re: change Tabs by seconds

HI Yadurand,

Not working da.

Sandeep

Community Browser