Skip to main content

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Vertical Data Text in Pivot Table

Hi,

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

vertical.PNG

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

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

View solution in original post

8 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

Not applicable
Author

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
MVP & Luminary
MVP & Luminary

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

Not applicable
Author

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

marcus_sommer
MVP & Luminary
MVP & Luminary

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

Not applicable
Author

Thanks for all!!

KasperJeppesen1
Contributor III
Contributor III

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! 

 

Group 3.png

marcus_sommer
MVP & Luminary
MVP & Luminary

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