topic Re: Strange Straight Table scroll with Timer Variable in Expression in QlikView

Strange Straight Table scroll with Timer Variable in Expression

Wed, 03 Sep 2014 07:30:00 GMT

Dear Experts,

As subject, I find it quite strange behavior if there is Timer Variable use in expression on Straight Table object (or any chart).

The table cannot be scroll, and always back to the top, though the timer variable already write in proper if condition in expression.

The case example is attached, the objective is to make autoscroll table (combine timer variable and rank function), with button trigger, so if the trigger is stop, then the table should can be scrolled manually by user.

The expression simply like this:

if(vstart=1,

if(mod(vmod,2)=1, sum(SALES)),

sum(SALES)

)

if vstart=0, then the table should be directly only evaluate sum(SALES), but unfortunately it seems the vmod keep being evaluated and cause the table state always back to top.

Any other solution to make 'live like' qlikview dashboard with autoscroll table rather than using timer variable?

Regards,

Alex

Re: Strange Straight Table scroll with Timer Variable in Expression

tresB — Wed, 03 Sep 2014 07:45:09 GMT

Not sure if understood your requirement right. However, I can scroll the chart with vstart=0

Re: Strange Straight Table scroll with Timer Variable in Expression

Wed, 03 Sep 2014 07:56:40 GMT

Thank you for your response.

Have you try to change vstart=1 (let the table blinking) and then set it back to 0,

then try to scroll down, can it keep at down or back to top?

I'm using SR7.

Re: Strange Straight Table scroll with Timer Variable in Expression

tresB — Wed, 03 Sep 2014 08:13:38 GMT

I guess this is because the expression is being re-evaluated frequently because of now(). Alternatively try preserving scroll position (Layout tab).

Re: Strange Straight Table scroll with Timer Variable in Expression

Wed, 03 Sep 2014 09:16:03 GMT

Wow, preserve scroll position is the answer.

It works exactly as expected, thank you very much tresesco...