topic Re: Rotate Text in Pivot Chart in QlikView

Rotate Text in Pivot Chart

Anonymous — Thu, 16 Jul 2015 21:38:48 GMT

Hey Everybody,

do you know if it's possible to rotate the text some, not all, dimensions of a pivot chart?

so i rotate the header as an example like here:

Might need to do that as well for the expressions

Re: Rotate Text in Pivot Chart

Fri, 17 Jul 2015 03:17:14 GMT

HI,

It will work for straight table and pivot table

r.click->chart properties-> presentation tab ->Vertical columns labels click the check box

it will work for dimensions as well as expressions.

I hope it will help u to complete u r task.

Thanks and Regards,

Balaji.k

Re: Rotate Text in Pivot Chart

Anonymous — Fri, 17 Jul 2015 05:18:43 GMT

Seem that, tried that, nothing is changing.

Re: Rotate Text in Pivot Chart

qlikmsg4u — Fri, 17 Jul 2015 05:24:22 GMT

chart properties-> presentation tab ->Vertical columns labels click the check box

Re: Rotate Text in Pivot Chart

Anonymous — Fri, 17 Jul 2015 05:27:02 GMT

I have seen this option and i checked it for all needed dimensions and the expression but it's still horizontal

I'm on QlikView 11.20.12742.0

Is that a bug??

Re: Rotate Text in Pivot Chart

phaneendra_kunc — Fri, 17 Jul 2015 05:27:50 GMT

see attached.

Re: Rotate Text in Pivot Chart

Anonymous — Fri, 17 Jul 2015 05:38:57 GMT

found the problem.. it seems it works only if all columns are next to each other.

May Layout is like this though"

As soon as i move some dimensions to the top it goes back to horizontal

So what i want is Desc, Level6, Level5, Level4 and the expression being vertical and the rest (so the part on the left side) horizontal..

Re: Rotate Text in Pivot Chart

MayilVahanan — Fri, 17 Jul 2015 05:42:30 GMT

As per my knowledge, you can't able to do it

Re: Rotate Text in Pivot Chart

phaneendra_kunc — Fri, 17 Jul 2015 06:12:06 GMT

I don't think you can do that with out of the box pivot table. You might have to build an extension to that.

But why do you have this requirement. You are goign to loose lot of real-state as all these vertical labels will take lot of space.

Re: Rotate Text in Pivot Chart

marcus_sommer — Fri, 17 Jul 2015 06:23:58 GMT

As a workaround you could rotate it manually - here is an example Re: Vertical Data Text in Pivot Table to rotate dimension-values and not the dimension-names but I think it could be adapted.

- Marcus

Re: Rotate Text in Pivot Chart

qlikviewwizard — Fri, 17 Jul 2015 14:10:23 GMT

Good post