topic Re: Wrap Text in Label of a Formula in QlikView

Wrap Text in Label of a Formula

Fri, 25 Apr 2014 09:35:02 GMT

Hi guys,

i hope somebody of you can help me with a tiny problem.

I want to wrap the text of the label of a formula.

For example the label (or naming) of the Formula is
"FINAL 2013".

I want to have it in two lines, like:

"FINAL

2013"

It still must work if the columns are expanded.

In Excel it works with the shortkey alt return. But this seems not working here

thanks,

Christian

Re: Wrap Text in Label of a Formula

Fri, 25 Apr 2014 09:38:18 GMT

Chart properties > Presentation > Wrap Header Text (Tick option) > "Increase numer to 2 for example"

Re: Wrap Text in Label of a Formula

Fri, 25 Apr 2014 09:48:27 GMT

Hi Felim,

thaks for the quick answer. The point ist it does not really help, because your solution just works if the columns are not wide. Unfortunatelly I have wide columns then it does not work.

Best regards,

Christian

Re: Wrap Text in Label of a Formula

MK_QSL — Fri, 25 Apr 2014 09:48:59 GMT

Check enclosed file...

Re: Wrap Text in Label of a Formula

Fri, 25 Apr 2014 09:51:58 GMT

If your formula you could use "& CHR(10) &" this is a carriage return

Re: Wrap Text in Label of a Formula

Fri, 25 Apr 2014 09:52:35 GMT

@Felim: You are too fast

Re: Wrap Text in Label of a Formula

Fri, 25 Apr 2014 09:55:28 GMT

Just trying to get my company up and running on the Qlikview scene so have to be fast and helping people the best way

Re: Wrap Text in Label of a Formula

Fri, 25 Apr 2014 10:17:57 GMT

Hi Felim, hi Sabal,

thank that was the solution. Nice weekend,

Christian

Re: Wrap Text in Label of a Formula

prem_1961 — Thu, 24 Feb 2022 14:57:35 GMT

"& CHR(10) &" does not work, I don't know if it was working at that time.