topic Re: Wrapping dimension text using chr13 in QlikView

Wrapping dimension text using chr13

alisonpwallis — Wed, 09 Jul 2014 14:04:42 GMT

Dear All,

I am trying to create a wordwrap on the dimension labels for a chart. I've created the following calculation:

=left([Program Title],15)& chr(13)&mid([Program Title],16)

My questions are :

Is there a way of making it so that the split occurs between a specific number of words rather than just after the 15th character?

Also, this is not actually working - I get the first part of the Program Title and then a big space and the second part doesn't appear at all. What is wrong with my syntax? Or is there something I'm missing somewhere else?

Thanks for your help

Alison

Re: Wrapping dimension text using chr13

sasikanth — Wed, 09 Jul 2014 14:15:06 GMT

The approch you are using is not correct , bcz

all the dimension values not have space at 15th charecter, so try to do this

like divide the sentence by 'space' first/second of your choice...

that wil look good than the previous,

for this use subfield function

Re: Wrapping dimension text using chr13

Gysbert_Wassenaar — Wed, 09 Jul 2014 14:18:14 GMT

In some charts (bar and line chart for example) it's not possible to wrap dimension values over multiple lines. In others you need to enable the option Wrap Cell Text.

Re: Wrapping dimension text using chr13

alisonpwallis — Wed, 09 Jul 2014 14:26:10 GMT

Thanks for your help. How do I enable the Wrap Cell Text? I've tried doing this in the presentation tab of the chart but this just seems to change it for the legend and not for the dimension.

Re: Wrapping dimension text using chr13

alisonpwallis — Wed, 09 Jul 2014 14:27:04 GMT

Hi, thanks for your help. I've had a go at putting it in the subfield function instead - but what if i don't know how many words there are going to be? I can write something to enter a carriage return after the 3rd word, but how do I just get the rest of the label?

Re: Wrapping dimension text using chr13

rbecher — Wed, 09 Jul 2014 14:30:46 GMT

You could use a calculated dimension like this:

replace(<DimensionField>, ' ', chr(13))

But it will look strange if you have more than two words. Even a two line label takes a lot of space and could cross the next one..

Gysbert Wassenaar this works for line and bar charts, too.

- Ralf

Re: Wrapping dimension text using chr13

agomes1971 — Wed, 09 Jul 2014 14:33:18 GMT

See caption...

I hope it helps

Kind regards

André Gomes

Re: Wrapping dimension text using chr13

Gysbert_Wassenaar — Wed, 09 Jul 2014 14:51:18 GMT

Can you post an example document for me? I can't seem to make that work.

Re: Re: Wrapping dimension text using chr13

rbecher — Wed, 09 Jul 2014 15:04:45 GMT

Here we go..

Re: Wrapping dimension text using chr13

alisonpwallis — Wed, 09 Jul 2014 15:08:50 GMT

HI Ralf

Thanks for posting this. I've tried it but I think there must be some other setting applied somewhere that is stopping it from showing all the lines. I just get the first word for each label rather than several lines....

Would a theme or something like that prevent it from showing?

Thanks

Alison

Re: Re: Wrapping dimension text using chr13

rbecher — Wed, 09 Jul 2014 15:13:57 GMT

Maybe it's version related?

Re: Wrapping dimension text using chr13

alisonpwallis — Wed, 09 Jul 2014 15:20:48 GMT

I can open your example file and it works like the image that you've posted here....

I'll keep trying different things!

Thanks again for your help

Re: Wrapping dimension text using chr13

Gysbert_Wassenaar — Wed, 09 Jul 2014 15:26:24 GMT

No, it's not version related afaict. But it only works with the dimension label orientation set to diagonal or vertical. And only for the default Orientation style.

Re: Wrapping dimension text using chr13

alisonpwallis — Mon, 14 Jul 2014 08:29:21 GMT

Hi All

Thanks for your help with this. Following Gysbert's answer I think it seems to be that I can only wrap the text on the vertical orientation. I wanted to have the text horizontal (because it's so long!) so I think this may not be possible. Perhaps it will come in a new version of Qlikview.

Thanks

Alison