Vertical Data Text in Pivot Table

[#1]

Hi,

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

[marcus_sommer · Accepted solution]

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

[#3]

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?

[marcus_sommer]

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

[#5]

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

[marcus_sommer]

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

[#7]

Thanks for all!!

[KasperJeppesen1]

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! 

[marcus_sommer]

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