How to Rotate a Text 90 Degrees? - Qlik Community

Report Inappropriate Content · ‎2014-07-21

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

alexandros17 · ‎2014-07-21

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

alexandros17 · ‎2014-07-21

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

Report Inappropriate Content · ‎2014-07-21

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?

stigchel · ‎2014-07-21

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...

alexandros17 · ‎2014-07-21

You have not other chances ...

Anonymous · ‎2014-07-21

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>

Report Inappropriate Content · ‎2014-07-21

Sounds like a joke to me

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

stigchel · ‎2014-07-21

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

Report Inappropriate Content · ‎2015-03-25

Haha good joke!

What stupid that this is impossible!