Change selection list box after 15 seconds

Thu, 28 Apr 2011 16:37:23 GMT

For a client I have to build an online dashboard. One of the requirements of the dashboard is that curtain selections in a list box change after 15 seconds. The client must also be able to pause the auto change and to resume the auto change.

I already found out how to change a chart every 15 seconds. I did this by making five seperate graphs with an condtional show.

This is not sufficient because the selection has to change every 15 seconds and with it the charts. Beneath is the code I used to the make the charts change.


Timing:
LOAD
Seconds
,rangesum(peek(PrevSumSeconds),peek(Seconds)) as PrevSumSeconds
INLINE [
Seconds
15
15
15
15
15
];
SET vSeconds = mod(round((now()-now(2))*86400),sum(Seconds));

The condtion for the charts are

floor(vSeconds /15)=0, floor(vSeconds /15)=1, floor(vSeconds /15)=2, floor(vSeconds /15)=3, floor(vSeconds /15)=4, floor(vSeconds /15)=5

Basicly I have three questions to be answered.

First, how do I make a list box change the selection every 15 seconds (instead of a chart)?

Second, how do I pause the auto change of the list box?

Third how do I resume the auto change of the list box?

Re: Change selection list box after 15 seconds

Thu, 16 May 2013 10:19:15 GMT

Hi frank,

Did you found any solution on this..I have the same requirements..

Best regards,

Nikolaos Kavroulakis

Re: Change selection list box after 15 seconds

Mon, 10 Jun 2013 14:02:44 GMT

Hey Nikolaos,

I managed to get it work. I think I did itby creating a second sheet which is conditionally shown when the pause button was pressed.

If you need any help, let me know.

gr.

Frank

topic Re: Change selection list box after 15 seconds in QlikView

Change selection list box after 15 seconds

Re: Change selection list box after 15 seconds

Re: Change selection list box after 15 seconds