topic Re: Automatic Switching of Tabs in Ajax Client in QlikView

Automatic Switching of Tabs in Ajax Client

Wed, 04 Apr 2012 16:44:51 GMT

I currently have a QV desktop application that runs on a large screen.

Every 15 seconds, it switches from one tab to the next using a condition on the tab that looks at the time.

Can anyone suggest how I could achieve a similar function using the Ajax client

Thanks

Dave

Re: Automatic Switching of Tabs in Ajax Client

jonathandienst — Wed, 04 Apr 2012 17:10:03 GMT

Dave

Define the following variables:

Set vDelay = 15; // duration of screen in seconds

Set vSheets = 10; // number of sheets

Set vShow = =ceil((frac(now())*86400/(vSheets*vDelay)-floor(frac(now())*86400/(vSheets*vDelay)))*(vSheets));

(the double = sign is not a misprint)

Now for each sheet, set the conditionally show to

(vShow = 1) // for the first sheet

(vShow = 2) // for the next sheet

... and so on.

vShow is updated continuously and counts from 0 to vSheets-1, incrementing every vDelay seconds.

This approach should work in both the plugin and in Ajax.

Regards

Jonathan

Re: Automatic Switching of Tabs in Ajax Client

Fri, 23 Aug 2013 13:02:21 GMT

Hi Jonathan,

Can you please explain the logic behind the vShow function???

I know that it works but i dont properly understand how ....why do we multiply by 86400 first of all...

Thanks in advance

Regards,

Re: Automatic Switching of Tabs in Ajax Client

jonathandienst — Fri, 23 Aug 2013 13:20:33 GMT

vShow increments by one every vDelay seconds up to vSheets, where it starts at 1 again. 86400 is the number of seconds in a day, so this is converting the time portion of now() to seconds after midnight. The calculation is then done in seconds.

Regards

Jonathan

Re: Automatic Switching of Tabs in Ajax Client

Tue, 01 Apr 2014 17:26:17 GMT

Jonathan - I've tried your approach to this but it doesn't seem to loop back through in AJAX. Have you made any more progress on this since this post?

Re: Automatic Switching of Tabs in Ajax Client

Tue, 07 Oct 2014 16:57:36 GMT

Has anyone had any luck with this? I am having the same issue with AJAX.

Re: Re: Automatic Switching of Tabs in Ajax Client

ashfaq_haseeb — Tue, 07 Oct 2014 17:33:59 GMT

Hi,

You need to have a look at this document on how to configure the same on AJAX.

Let me know if that worked.

Regards

ASHFAQ

Re: Automatic Switching of Tabs in Ajax Client

stevedark — Tue, 14 Oct 2014 18:43:14 GMT

Hi Emilio,

How I have gone about this in the past is by having QlikView display in an iFrame and have an HTML timer refreshing the host page. The QlikView URL can then have a parameter to set a field value that fires a trigger to show the correct page.

See this post on Ajax parameters, and my comment on the third page around getting triggers to fire.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/07/11/ajax-and-url-parameters

Hope that helps,

Steve