topic Re: How to Rotate a Text 90 Degrees? in QlikView

How to Rotate a Text 90 Degrees?

Mon, 21 Jul 2014 14:55:21 GMT

Hi!

I have a text displayed via a text box and would like to rotate it 90 degrees counter clockwise (actual rotation), but I can't find a way to configure that.

Is it possible?

The text might be dynamic, which is why I can't use a picture.

---

I decided to dedicate a joke to every obviously missing feature in QlikView:

How many Scotsmen do you need to rotate a text box in QlikView?

Two - One who creates the text box and another who rotates the screen!

But - seriously - there is no way justifying that QlikView is not providing this obvious feature now for 11 versions - it's more of a sad joke.

Enjoy!

Kind regards

Raffael

Re: How to Rotate a Text 90 Degrees?

alexandros17 — Mon, 21 Jul 2014 14:56:13 GMT

If it isn't a dynamic text then use an image ...

Re: How to Rotate a Text 90 Degrees?

alexandros17 — Mon, 21 Jul 2014 14:57:09 GMT

Otherwise resize the text box setting width to minimum and increasing height, you'll see text in vertical

Re: How to Rotate a Text 90 Degrees?

Mon, 21 Jul 2014 14:59:42 GMT

Regarding the image-solution - I would like to potentially use dynamic textual content.

Regarding your resizing-solution - this displays the text top to bottom but not rotated.

Any further ideas?

Re: How to Rotate a Text 90 Degrees?

stigchel — Mon, 21 Jul 2014 15:06:51 GMT

Yes, it is quite a work around but you could make a chart with the text as dimension (e.g. ValueList('MyText'), an expression with some e.g. negative value (out of the scale so it does not display). After that start hiding all the axes, transparent background.....and offcourse set the labels to display vertical on the axes tab of the properties

Or a table with vertical text on header...

Re: How to Rotate a Text 90 Degrees?

alexandros17 — Mon, 21 Jul 2014 15:08:09 GMT

You have not other chances ...

Re: How to Rotate a Text 90 Degrees?

Anonymous — Mon, 21 Jul 2014 15:09:46 GMT

there is a way using an extension - minimilastic text box...you can then use html/css to rotate your text

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

then use the following example html code - (straight from w3schools.com) in single quotes just like you would do a regular text as expression.

<!DOCTYPE html>
<html>
<head>
<style>
div
{
width:200px;
height:200px;
background-color:yellow;
/* Rotate div */
transform:rotate(270deg);
-ms-transform:rotate(270deg); /* IE 9 */
-webkit-transform:rotate(270deg); /* Opera, Chrome, and Safari */
}
</style>
</head>
<body>

<div>Hello</div>

</body>
</html>

Re: How to Rotate a Text 90 Degrees?

Mon, 21 Jul 2014 15:10:13 GMT

Sounds like a joke to me

How many Scotsmen do you need to rotate a text box in QlikView ... ?

Re: How to Rotate a Text 90 Degrees?

stigchel — Mon, 21 Jul 2014 15:27:33 GMT

Yes, why there isn't a more configurable textbox out of the box, I don't understand as well...

Re: How to Rotate a Text 90 Degrees?

Wed, 25 Mar 2015 12:12:46 GMT

Haha good joke!

What stupid that this is impossible!

Re: How to Rotate a Text 90 Degrees?

Fri, 27 Nov 2015 21:19:14 GMT

Yeah, don't understand how such basics things are not included in Qlik solution !!

i have a quite same issue if someone has an idea ... ?

Vertical Label