topic Re: Marquee in QlikView

Marquee

VishalWaghole — Wed, 04 Dec 2013 09:27:16 GMT

Hi Community,

I want moving strip at bottom of my Dashboard, that moving strip show me transacted data..

Is it possible?? and if yes then please guide me.

Thanks and Regards,

Vishal Waghole

Re: Marquee

Wed, 04 Dec 2013 09:34:50 GMT

Hi Vishal,

These might be of help:

http://community.qlik.com/docs/DOC-4305

Or you can refer to this as well:

http://community.qlik.com/message/395380

Hope this helps!

Re: Marquee

marcohadiyanto — Wed, 04 Dec 2013 09:44:51 GMT

check this out, i think its same issue with you

http://community.qlik.com/message/395380#395380

Re: Marquee

VishalWaghole — Wed, 04 Dec 2013 09:47:26 GMT

Hi Shyamal,

Firstly thanks for your valuable reply to my Question.

I have already gone through with this Document but that one is Static.

and I want retrieve data from database or Qvd and then display on strip..

For eg. News Channels moving Current news at bottom screen.

Thanks and Regards,

Vishal Waghole

Re: Marquee

Wed, 04 Dec 2013 09:59:42 GMT

Hi Vishal,

Have a look at this one:

http://analyse-that.com/qlikview-animated-bulletin-board-rotating-text/

Re: Marquee

Wed, 04 Dec 2013 12:26:56 GMT

Hi,

I have used below expression in my text object. and it worked.

=Left(ScrollText , 1+mod(round((now(1)-now(0))*86400), Len(ScrollText)))

Note: ScrollText is variable where,

ScrollText ='This application is desinged for easy access of Offshore team details. '

As you are getting the data from the other source, you can assign field name to the variable and pass it.

Hope it helps you.

Re: Marquee

VishalWaghole — Thu, 05 Dec 2013 05:24:03 GMT

Hi Shamshunnisa,

Thanks for this answer but if i want to increase moving speed of Text,

Then how should i do it??

Thanks and Regards,

Vishal Waghole

Re: Marquee

jagan — Thu, 05 Dec 2013 06:56:33 GMT

Hi,

It is not possible to increase the speed because the value changes for every second, nothing less than that, check below from Qlikview help file.

Also, don't use Now(), it hurts the performance.

now([ timer_mode])

Returns a timestamp of the current time from the system clock. The timer_mode may have the following values:

0 Time at previously finished reload (not currently ongoing reload)
1 Time at function call
2 Time when the document was opened

Default timer_mode is 1. The timer_mode = 1 should be used with caution, since it polls the operating system every second and hence could slow down the system.

Regards,

Jagan.

Re: Marquee

Thu, 05 Dec 2013 08:06:49 GMT

Do a trail and error method.

I'm using 86400. Increase the value and check the speed. You can set the speed according to your requirement.

Re: Marquee

Thu, 05 Dec 2013 08:13:01 GMT

Thank you Jagan. I was not aware of the this.