topic Scroll text Expression in QlikView

Scroll text Expression

kakani87 — Mon, 18 Jun 2018 06:06:41 GMT

Hi All,

Here it is displaying a text which is scrolling by using this expression

=left(vScroll,mod(Round((now()-now(2))*100000),len(vScroll)+1))

Assigned Text to the variable =vScroll

Can some one explain this logic.

Re: Scroll text Expression

kakani87 — Mon, 18 Jun 2018 08:37:17 GMT

Hi ..

tresesco‌

stalwar1‌

Re: Scroll text Expression

sunny_talwar — Mon, 18 Jun 2018 09:03:25 GMT

What do you not understand about the expression? I mean is there a part of the expression you are trying to understand better because the expression might be complex, but the logic seems rather simple where based on the time difference between Now() and Now(2) the number of letters shown increase by 1.

Re: Scroll text Expression

kakani87 — Mon, 18 Jun 2018 10:04:09 GMT

Why this time difference *100000 is considered

apart from 100000 other value is not working, is there any particular reason

Re: Scroll text Expression

sunny_talwar — Mon, 18 Jun 2018 11:25:47 GMT

Actually, the best number to use here would be 86,400 which is equivalent of a single second.

Re: Scroll text Expression

kakani87 — Mon, 18 Jun 2018 12:17:17 GMT

Thank a lot Sunny.

So 86,400 will be seconds

where 1 day = 86,400 seconds