topic Trying to Loop through Sheets in a Dashboard Continually in QlikView

Trying to Loop through Sheets in a Dashboard Continually

Wed, 05 Jan 2011 19:52:51 GMT

Hi all,

Trying to put together a dashboard that contains (e.g. 10 sheets) each with different content.

I'd like to have a sheet with a button that kicks off a loop that displays each sheet for (e.g. 10 seconds) and then moves on to the next one.

I've used a little code like this:

for i = 0 to ActiveDocument.NoOfSheets - 1
ActiveDocument.Sheets(ActiveDocument.Sheets(i).GetProperties.Name).Activate
ActiveDocument.GetApplication.Sleep 5000
next

But I can't seem to get the desktop client to actually show any page between the first and the last page, let alone get it looping through continually. When I apply the above code to a macro attached to a button, it whirrs away but only displays the final sheet....never showing the intermediate sheets.

Any ideas?

Many thanks!

Nick

Trying to Loop through Sheets in a Dashboard Continually

Oleg_Troyansky — Wed, 05 Jan 2011 20:19:56 GMT

Add WaitForIdle into your loop:

for i = 0 to ActiveDocument.NoOfSheets - 1
ActiveDocument.Sheets(ActiveDocument.Sheets(i).GetProperties.Name).Activate
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.GetApplication.Sleep 5000
next

Trying to Loop through Sheets in a Dashboard Continually

johnw — Thu, 06 Jan 2011 00:50:30 GMT

It starts automatically instead of being controlled by a button, but attached is one way of handling this sort of requirement without a macro. A table defines how long it should spend on each sheet, and then a display condition on each sheet determines when that sheet should display. You could easily kick it off with a button by, say, having the button set a variable that the condition for each sheet also checks.

Trying to Loop through Sheets in a Dashboard Continually

Thu, 06 Jan 2011 09:04:49 GMT

John/Oleg,

Thank you both so very much for your help - I've learned something from both your responses.

All the best,

Nick

Trying to Loop through Sheets in a Dashboard Continually

Wed, 25 Apr 2012 15:01:43 GMT

Hello friend, this loop with macro how do I stop running when you click the button again?

Re: Trying to Loop through Sheets in a Dashboard Continually

Anonymous — Thu, 26 Feb 2015 14:11:33 GMT

Did this code "WaitForIdle" crash your application?