topic Re: Vertical Text in Pivot Table problem in QlikView

Vertical Text in Pivot Table problem

lawrenceiow — Mon, 24 Nov 2014 10:19:10 GMT

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.

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.

Re: Vertical Text in Pivot Table problem

Gysbert_Wassenaar — Mon, 24 Nov 2014 10:31:44 GMT

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

Re: Vertical Text in Pivot Table problem

lawrenceiow — Mon, 24 Nov 2014 10:37:18 GMT

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

Re: Vertical Text in Pivot Table problem

c_gilbert — Mon, 24 Nov 2014 11:00:57 GMT

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

Re: Re: Vertical Text in Pivot Table problem

lawrenceiow — Mon, 24 Nov 2014 11:34:05 GMT

Please see attached

Re: Re: Vertical Text in Pivot Table problem

lawrenceiow — Mon, 24 Nov 2014 11:36:27 GMT

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.

Re: Vertical Text in Pivot Table problem

Gysbert_Wassenaar — Mon, 24 Nov 2014 11:40:54 GMT

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.

Re: Vertical Text in Pivot Table problem

ashwanin — Mon, 24 Nov 2014 11:47:39 GMT

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

Re: Vertical Text in Pivot Table problem

lawrenceiow — Mon, 24 Nov 2014 11:49:28 GMT

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.