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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
alisonpwallis
Creator
Creator

Wrapping dimension text using chr13

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

Labels (1)
13 Replies
rbecher
Partner - Master III
Partner - Master III

Maybe it's version related?

Wrap.PNG.png

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine
alisonpwallis
Creator
Creator
Author

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

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand
alisonpwallis
Creator
Creator
Author

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