topic Re: Vertical Text on Column sizing issue in QlikView

Vertical Text on Column sizing issue

Tue, 11 Mar 2014 10:14:39 GMT

Hi,

Having some trouble with the formatting of a pivot table, please see attached for screenshots of the issue i'm having.

The problem i'm having is that the sizing of a the vertical text on column header is too long!

In the options i have seleceted --> Presentation - vertical text on columns tick box. There is only one expression in the table and that is an if statement that either shows 1, or if there is a booking it will show information about that booking by way of concatenating a number of dimensions together. The reason i do that is it means when a user hovers over it will display this useful information.

The problem I'm having is that for every extra dimension i concatenate it make the vertical text column longer and as a result as you can see in the screenshot it make the table unusable.

Do you have any idea how i can either just resize this column, or if there is another solution to this problem.

Thanks

Re: Vertical Text on Column sizing issue

veidlburkhard — Tue, 11 Mar 2014 10:29:42 GMT

Hi Hemant,

Go on 'Chart Properties', 'Presentation' tab there you'll find the 'Multiline Settings'. Please tick the 'Wrap header text' check box and enter 2 or 3 or whatever you want to have a number of lines for your header text. See example below:

Hope this helps.

Regards

Burkhard

Re: Vertical Text on Column sizing issue

Tue, 11 Mar 2014 10:45:38 GMT

Hi Burkhard,

Thanks for the suggestion. That does work but ideally was wanting a way to keep the label vertical. The option you've suggested means the formatting doesn't look quite right as i have to widen the columns a touch, and the text displays as follows:

Re: Vertical Text on Column sizing issue

sunilkumarqv — Tue, 11 Mar 2014 10:58:07 GMT

Hi Hemant ,

Changes the Fit to Columns to Data and Equal Column width -right click on chart

Re: Vertical Text on Column sizing issue

Tue, 11 Mar 2014 11:03:03 GMT

Hi Sunil,

Afraid this ends up with the opposite effect of having not only very tall headers but also very wide ones!

If you look at my attachment its important that the expression cells retain a small square shape as its just the colour of the cell that is important.

thanks

Hem

Re: Vertical Text on Column sizing issue

veidlburkhard — Tue, 11 Mar 2014 11:34:18 GMT

Any chance, Hemant, to shorten your long text. I mean you can cut 'JOB ID '. May be you can create a short version for the header of this your pivot table...

Only to think about

Burkhard

Re: Vertical Text on Column sizing issue

sunilkumarqv — Tue, 11 Mar 2014 11:42:23 GMT

Can you attached sample one

Re: Vertical Text on Column sizing issue

lawrenceiow — Mon, 24 Nov 2014 12:03:40 GMT

Hemant Patel, I don't know if you're still needing an answer to this as your post is old. But, just in case. I had the same issue with a stupidly tall vertical column header row. I posted my issue after searching the community and not finding the answer, I did come across yours though.

I was provided an answer by the legend known as Gysbert Wassenaar, it turns out the issue was that I had not provided a label for the expression and so the height of the box became the length of the expression formula. I set the label to =' ' (single space) and this cured the problem.

Re: Vertical Text on Column sizing issue

Anonymous — Thu, 25 Aug 2016 21:45:23 GMT

Thanks Lawrence, this was a great tip (especially because it's something so unintuitive...i never would have guessed it on my own)

Re: Vertical Text on Column sizing issue

lawrenceiow — Fri, 26 Aug 2016 08:17:43 GMT

Glad this worked for you Aaron. I've been finding a number of things that seem unintuitive. I think that's where this community becomes really helpful.