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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
lawrenceiow
Creator II
Creator II

Vertical Text in Pivot Table problem

How do I fix this problem I'm having when I select "Vertical Text on Column Labels" option in the "Presentation" tab of the pivot table Chart Properties. Each column is too wide for horizontal use so I changed to vertical text but now the heading row is ridiculously tall.

untitled.PNG

I tried changing the label to =' ' just in case it was the label that was causing the problem.

The hour time being displayed is coming from an inline table linked to the FactTable:

ActualTime,HourBand,HourBandTxt

00:00, 00:00, '00:00'

00:01, 00:00, '00:00'

00:02, 00:00, '00:00'

etc

23:59, 23:00, '23:00'

I added the third, "text" column in the vague hope that the issue was to do with date/time but this didn't work either.

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Set the label of the expression to a single space. That expression label is now empty so the length of the expression is used for the height of the header row.


talk is cheap, supply exceeds demand

View solution in original post

8 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Can you post a .qvw document that demonstrates the problem?


talk is cheap, supply exceeds demand
lawrenceiow
Creator II
Creator II
Author

OK, I'll try and knock up a sample I can upload.

c_gilbert
Creator II
Creator II

Check the 'Header Height' in the 'Multiline Settings' in the presentation tab.

lawrenceiow
Creator II
Creator II
Author

Please see attached

lawrenceiow
Creator II
Creator II
Author

Thanks for your reply Charlotte. This did not seem to make any difference. I tried to apply this whilst the text was vertical and it made no difference, I then tried to apply this whilst the text was horizontal and then made the text vertical afterwards - still not difference.

As requested by Gysbert I have uploaded a sample QVD file.


Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Set the label of the expression to a single space. That expression label is now empty so the length of the expression is used for the height of the header row.


talk is cheap, supply exceeds demand
ashwanin
Specialist
Specialist

Hi Lawrenceiow,

Follow the Gysbert's suggestion. It will solve your problem.

If you add any text in the label of expression ,It will automatically minimize the height.

Check your qvw here

lawrenceiow
Creator II
Creator II
Author

Awesome!  Thanks Gysbert Wassenaar, so fast a response too. I'd tried changing the dimension label to a single space as this was quite long in my original QVD, never occurred to me that the expression label was the issue.

Thanks again.