Loop Through Sheets and Dates

[rustyfishbones]

Hi,

I have a file that loops through each sheet every 15 seconds, the dataset is nothuge sheets change every 15 seconds without any issues.

I have no user interaction and I always have 3 days of information.

So I need to loop through each sheet for each date

So example

Sheet 1 15/02/2017 15 seconds later......

Sheet 2 15/02/2017 15 seconds later.....

Sheet 3 16/02/2017 15 seconds later.....

Sheet 1 17/02/2017 15 seconds later.....

Sheet 2 17/02/2017 15 seconds later.....

Sheet 3 17/02/2017 15 seconds later.....

Sheet 1 18/02/2017 15 seconds later.....

Sheet 2 18/02/2017 15 seconds later.....

Sheet 3 18/02/2017 15 seconds later.....

Again, I am currently looping through the sheets, but I am not looping through the dates as I want.

I tried using sheet triggers on leave by adding a select in field of the date, but that does not work

Hope you can help.

Regards

Alan

[adamdavi3s]

Weird... I just changed the variable to second(now()) and its merrily scrolling through

[rustyfishbones]

Hi Adam,

It does not work on the desktop version.

But.... it does work through access point with Full Browser. I have used it in Chrome and IE and it works.

I have it working on a variable called vShow, vShow changes every 30 seconds to 1,2 or 3 and back again based on the sheet change.

So I added the trigger on that variable, that changes the Date field, and it's working.

But I need to create a new variable that will only change the Date every 90 seconds. As I want the Date to remain for each 30 second view of the sheet and then change to the next date and continue that.

Trying that now.

Thanks

Alan

[rustyfishbones]

Hi Adam,

So another weird thing, the date changed when I use vShow which changes every 30 seconds.

But when I create my new variable vShow90, to show every 90 seconds (And it does change when I display it in a text object), when I add the trigger for that variable it does not change the date.

Both Variables are doing the same thing, so why would 1 work and the other not.

Really frustrating!!

[adamdavi3s]

Alan,

That is some weird behaviour, something obviously not OK in desktop!

To do 90 seconds I would add this formula in your variable:

=floor(floor((now() - DayStart(today()))*86400)/90)

[adamdavi3s]

I'd be logging it with Qlik I think.... something is obviously not working correctly!

[rustyfishbones]

Now it's working in Desktop!!

Going to check in AccessPoint now!!

Crazy!!

[adamdavi3s]

I love this type of behaviour