topic Rotate text in Text Object in QlikView

Rotate text in Text Object

Tue, 22 Jun 2010 10:02:11 GMT

Hi,

I need one Text Object where text enters from Right and move to Left - like we can see in many programming applications and websites.

Pls Suggest!!

Rotate text in Text Object

sparur — Tue, 22 Jun 2010 10:52:44 GMT

Hello, Arun.

in text object you can't rotate text 😞 I can suggest you one approach:

create an image with your text, rotate text in image. and then use this image as background for text object in QlikView

Rotate text in Text Object

Tue, 22 Jun 2010 11:41:13 GMT

Thanks for the approach.

But in my case, the text is not going to be fixed. It may change basis selection or basis data reload over the period of time.

Rotate text in Text Object

sparur — Tue, 22 Jun 2010 11:45:28 GMT

Unfortunately, I think it impossible in current version of QlikView

Rotate text in Text Object

johnw — Wed, 23 Jun 2010 00:29:22 GMT

The trick might be finding something in QlikView that DOES display text vertically, then removing everything EXCEPT the text. I'm not sure this is the best object to use, but here's an example using a scatter chart, which allows you to display text vertically along the Y axis. I wasn't sure how to remove the Y axis numbers, so I covered them with a blank white text box. In the example, you would just put your text expression as the label for the second expression in the scatter chart. For my example, I let you select the text to display vertically from a list box.

Edit: Actually, I probably misunderstood the requirement. What do you mean by "enters from Right and move to Left"?

Rotate text in Text Object

disqr_rm — Wed, 23 Jun 2010 02:08:03 GMT

Hi John, Thanks for great idea even if you misunderstood. 🙂 I am sure this is useful in many place.

Hi Arun,

I think you are looking to scroll the text in a text box. The only possibility I know is animated GIF, but that's not an option for you it seems. Another thing could be tried is multiple variables shown conditionally with now() command refreshing a text box.

Rotate text in Text Object

Wed, 23 Jun 2010 05:48:25 GMT

Hi Rakesh,

By using now() it works but the CPU utilization is very high.

Regards,

Ravi

Rotate text in Text Object

johnw — Wed, 23 Jun 2010 17:37:09 GMT


Ravi wrote:By using now() it works but the CPU utilization is very high.

Hmmmm, not really, or at least not on my machine. Using now() can be dangerous depending on HOW it is used, but for something simple like a text object or a simple clock, not a problem. On my ancient PC, this is using 0% CPU. Yes, I know it's using SOME CPU, but not enough for Task Manager to bother reporting.

Anyway, attached is an example of scrolling text using expressions instead of multiple variables shown conditionally. The main issue I see is that now() is only updated every second, so your text object is only updated every second, which makes for a pretty slow scroll.

Here's the expression for my text object:

=left(MyText,mod(round((now()-now(2))*86400),len(MyText)))

Edit: And all that said and done, my advice is DON'T DO IT. Scrolling text, blinking text, drop shadows, all of that kind of thing are DISTRACTIONS from the actual information you're trying to present. Most web designers have figured that out over the past twenty years. Just because you CAN do something doesn't mean you SHOULD. Flashy is not useful. It might look good for a demo, but when you're using the software day in, day out, it gets very old very fast.

Rotate text in Text Object

Fri, 25 Jun 2010 10:59:14 GMT

Hi john,

Thanks for your easy solution & suggestion.

Regards,

Ravi

Rotate text in Text Object

Fri, 18 Feb 2011 16:40:46 GMT

hi bob,

this scrolling text feature is excellent.

have you found a work around the reload problem so that the text scrolls all the time?

Re: Rotate text in Text Object

alec1982 — Fri, 29 Jun 2012 14:07:38 GMT

Hi John,

Thank you for the great example.

is it possible to explain to me how is the method works.

=left(MyText,5*mod(round((now()-now(2))*86400),ceil(len(MyText)/5)+10))

I see Mytext as a Variable.

How to control the speed on the text so it will move constantly without stopping and moving again.

Thxs,

Alec

Re: Rotate text in Text Object

Thu, 21 Mar 2013 12:22:20 GMT

There is a work around:

Settings -> Document Properties -> Triggers -> Document Event Triggers -> On Open

Click Add Action(s)... button

Click Add button

Action Type = External

Action = Reload

Now the Document will reload automatically when you open it. (This is useless if that your reload takes ages......)

Re: Rotate text in Text Object

Fri, 17 Jan 2014 05:18:46 GMT

Hi Arum,

are you looking for marquee effect then it will help you,

try this

Mid('$(v_text)'&'-'&'(v_text)',mod(floor(100000*now()-today()),len('$(v_text)')),len('$(v_text)'))

where " v_text " is a variable in which you can write the any text you to write

Regards

harshal

Re: Rotate text in Text Object

Fri, 14 Mar 2014 07:56:50 GMT

Hi John,

This works perfect! But it is not working in the webview.

Do I need to change any settings to reflect the same in Webview?

BR,

Arun.

Re: Rotate text in Text Object

Anonymous — Mon, 12 May 2014 06:36:57 GMT

Hi everyone,

Here I'm facing problem that how to make image with rolling text.

Re: Rotate text in Text Object

Anonymous — Wed, 09 Jul 2014 08:33:01 GMT

Hi ArumMittal,

We can use the "text in chart" option available in charts
Create a bar chart with a dummy expression (say 1) and hide the bar by using white colour

Chart -> Presentation -> Text In Chart , write your expression here which will give dynamic results.
There we have option to rotate the text to any Angle (Degree). Hope this helps you

Thanks

Raja.

Re: Rotate text in Text Object

Anonymous — Wed, 09 Jul 2014 08:42:30 GMT

Hi,

Hope this helps you

Marquee/Ticker Extension.

Thanks,

Raja

Re: Rotate text in Text Object

gaurav2017 — Sun, 16 Nov 2014 17:39:11 GMT

Dear Arum,

I have a similar problem. I want to show data in below format where these values change automatically and should be random at every second.

For reference, check out the link: http://www.moneycontrol.com/stocksmarketsindia/