topic Vertical Data Text in Pivot Table in Qlik Learning Discussions

Vertical Data Text in Pivot Table

Thu, 26 Feb 2015 16:51:52 GMT

Hi,

can see the data in vertical for dimension like the image?

Re: Vertical Data Text in Pivot Table

marcus_sommer — Fri, 27 Feb 2015 07:48:48 GMT

This isn't possible - the qv objects have no options to turn text or to have different font-types, font-sizes and so on in one single (sub)-object. But with an extension and CSS should it be possible - but maybe you could use instead the following as workaround:

fact:

Load * Inline [

Dimension, Value

Jon, 1

Bon, 2

Jovi, 3

];

verticalPrepare:

Load distinct Dimension, mid(Dimension, iterno(), 1) as vDimension, iterno() as IterNo

Resident fact while iterno() <= len(Dimension);

verticalFinal:

NoConcatenate Load Dimension, concat(vDimension, chr(10), IterNo) as vDimension

Resident verticalPrepare group by Dimension;

drop tables verticalPrepare;

- Marcus

Re: Vertical Data Text in Pivot Table

Fri, 27 Feb 2015 09:53:03 GMT

Hi Marcus,

very helpful workaround , I think it's possible to adapt at my project.

When you talk about an exstension, you're referring to a particularly one?

Re: Vertical Data Text in Pivot Table

marcus_sommer — Fri, 27 Feb 2015 10:06:40 GMT

No, I don't know a particularly one. I know only that you could do such adjustments wit CSS. Maybe you could something adapt from here: http://community.qlik.com/docs/DOC-7124 or from here: http://community.qlik.com/search.jspa?q=extension+chart

- Marcus

Re: Vertical Data Text in Pivot Table

Fri, 27 Feb 2015 10:15:47 GMT

Thanks for suggestion, but one more ... how can I make adjustments with CSS and without an exstensions?

Re: Vertical Data Text in Pivot Table

marcus_sommer — Fri, 27 Feb 2015 10:26:19 GMT

My practical experience with html + css are not very deep and it's many years ago - so I suggest you searched global for such new css-features. And you will need an extension and using an AJAX client - what meant that the qv-gui is a "normal" website which could be customized with extensions and css.

- Marcus

Re: Vertical Data Text in Pivot Table

Fri, 27 Feb 2015 10:56:13 GMT

Thanks for all!!

Re: Vertical Data Text in Pivot Table

KasperJeppesen1 — Wed, 06 Jan 2021 15:16:01 GMT

Hi @marcus_sommer

Do you know if this solution or another solution can work, to change the tabs in a pivot tabel from horisontal to vertical? As standard, they are shown as horisontal.

Thank you!

Re: Vertical Data Text in Pivot Table

marcus_sommer — Wed, 06 Jan 2021 16:14:54 GMT

No, I'm not very familiar with Sense yet and therefore I don't know if there are ways to set it and/or to customize it with any kind of extension.

- Marcus