topic Re: change Tabs by seconds in QlikView

change Tabs by seconds

fabio_vallone — Tue, 23 Apr 2013 14:03:47 GMT

Hi,

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

Re: change Tabs by seconds

Gysbert_Wassenaar — Tue, 23 Apr 2013 14:40:22 GMT

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

Re: change Tabs by seconds

fabio_vallone — Tue, 23 Apr 2013 14:43:33 GMT

Thanks!

Re: change Tabs by seconds

Tue, 23 Apr 2013 15:03:37 GMT

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

' 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

Re: change Tabs by seconds

fabio_vallone — Tue, 23 Apr 2013 15:05:59 GMT

Ok, I'll try.

Thanks!

Re: change Tabs by seconds

Thu, 30 May 2013 13:59:52 GMT

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!

Re: change Tabs by seconds

sandeepprasad_j — Fri, 31 May 2013 07:49:32 GMT

HI Grape ,

How to stop or cloase the document..

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

Thanks,

Sandeep

Re: change Tabs by seconds

stevedark — Fri, 31 May 2013 08:28:16 GMT

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&select=TRIGGER,0&sheet=OVIEW" width="100%" height="100%"></iframe>
</body>
</html>

Hope that helps you out.

Regards,

Steve

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

Re: change Tabs by seconds

Fri, 31 May 2013 08:37:58 GMT

hit escape ?

Re: change Tabs by seconds

sandeepprasad_j — Fri, 31 May 2013 08:55:54 GMT

HI Yadurand,

Not working da.

Sandeep

Re: change Tabs by seconds

Fri, 31 May 2013 09:57:07 GMT

Hi Steve

Thank you for your answer.

Yes, there is aprox 40 values in the field (storenumbers). What I am looking for is a module/macro to help me out. Can you help me with this?

Regards,

Rasmus

Re: change Tabs by seconds

stevedark — Fri, 31 May 2013 10:27:24 GMT

The code you need to advance through values in a field using an Action is this:

=if(isnull(minstring({1}if(Store> '$(=Only(Store))', Store, null()))), minstring({1}Store),minstring({1}if(Store> '$(=Only(Store))', Store, null())))

You could attach a trigger on selection of a field to Select In Field for this code. You could then load a data island with a field called Advance and values of just 0 and 1. If you place this on your document as a list box, and rename it to ADVANCE you could use the frame.html example I posted with just two frames. In frame1.html you would have &select=ADVANCE,0 and in frame2.html you would have &select=ADVANCE,1 . This way each time the browser refreshes the selection on that field would change, firing the trigger.

You cold do similar with code in a macro, but I believe that macro's do not always fire in the browser correctly.

Hope that helps,

Steve

http://www.quickintelligence.co.uk/