Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Bernhard_B
Contributor
Contributor

column headings in a new pivot table

Is it possible to create a line break (long headings) for the column headings in a new pivot table (Visualization bundle)? I have already tried everything here.

Labels (1)
2 Replies
Kushal_Chawda

@Bernhard_B Pivot Table does not provide a direct option to wrap text for column headers. However, you can achieve it using CSS if you have access to custom styling.

.qv-object-pivot-table .qv-st-header-cell {
    white-space: normal ;
    word-wrap: break-word ;
    text-align: center;
}
Qrishna
Master
Master

increase the header row height using html/css or try vizlib if your company has its license and  you can do line breaks in the text with chr(10)  like below

= 'This is a long Header' & chr(10) & 'hence using a Line Break Using chr(10)' & chr(10) & 'And Another Line break for the display'

This can done to the field values too:

2488446 - Line break in column headings in a new pivot table (2).PNG

you can do line breaks on field values too wih same methods

if you want to give line breaks on an existing field name, try storing the field name in a variable  and then do below:

try: = left('meas', 1) & chr(10) & mid('meas', 2, 1) & chr(10) & mid('meas', 3, 1) & chr(10) & right('meas', 1)

2488446 - Line break in column headings in a new pivot table (3).PNG