topic Re: Cycle data through variable every 30-seconds in QlikView

Cycle data through variable every 30-seconds

jcampbell474 — Thu, 21 Jan 2016 14:20:05 GMT

Good morning, everyone.

I have a unique task that I hope can be executed with a somewhat simple solution. I’ve searched all around the qlikview community and didn’t have any luck.

Here’s what I’m trying to do: I have one sheet that displays one (U.S) state at a time, along with 15 corresponding data points. The initial developer has it set up to conditionally show/hide the 15 charts for each state. So, any time a change is needed, at least 50 charts have to be updated. Some type of web script cycles through each state every 30 seconds. I haven’t seen it, yet.

We need to change it so that there are only 15 charts with a variable used in their expression and a function to cycle data through the variable every 30-seconds.

Here is the closest thing I could find, but it applies to sheets. We want to avoid 50 sheets, if possible. https://community.qlik.com/thread/17838

Any/all help is greatly appreciated.

Re: Cycle data through variable every 30-seconds

Thu, 21 Jan 2016 18:39:26 GMT

can you explain which script running or what are the conditions to show the charts?

Based on user selections or you need to show the new state chart on every 30 secs without user selections ??

Re: Cycle data through variable every 30-seconds

jcampbell474 — Thu, 21 Jan 2016 21:17:58 GMT

It's some type of asp script that I haven't seen.

There is no user interaction w/the app. It is displayed on a television and simply shows some key metrics for each state, cycling every 30-seconds. I dug deeper and found that it's only 12 states, not 50. (Thank goodness).