Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Scroll text Expression

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.

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Scroll text Expression

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

View solution in original post

5 Replies
Highlighted
Specialist
Specialist

Re: Scroll text Expression

Hi  ..

tresesco

stalwar1

Highlighted

Re: Scroll text Expression

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.

Highlighted
Specialist
Specialist

Re: Scroll text Expression

Why this time difference *100000 is considered

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

Highlighted

Re: Scroll text Expression

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

View solution in original post

Highlighted
Specialist
Specialist

Re: Scroll text Expression

Thank a lot Sunny.

So 86,400 will be seconds

where  1 day = 86,400 seconds