Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kakani87
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.

1 Solution

Accepted Solutions
sunny_talwar

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
kakani87
Specialist
Specialist
Author

Hi  ..

tresesco

stalwar1

sunny_talwar

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.

kakani87
Specialist
Specialist
Author

Why this time difference *100000 is considered

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

sunny_talwar

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

kakani87
Specialist
Specialist
Author

Thank a lot Sunny.

So 86,400 will be seconds

where  1 day = 86,400 seconds