topic Re: New line character in QlikView

New line character

sankar_ganesh — Sun, 10 Mar 2013 15:21:07 GMT

Hi,

I need to show the results of 2 expressions(sum(sales), sum(profit)) one by one, as shown in below , in a straight table.

chr(13) to insert a new line is not working in the chart expression , it works in text box only. Does any one have solution for this.

Country	Results
xxx	Sales: 1000 Profit : 150
yyy	Sales: 2000 Profit : 550
zzz	Sales: 3000 Profit : 1500

Thanks.,

Sankar

Re: New line character

Gysbert_Wassenaar — Sun, 10 Mar 2013 16:11:32 GMT

On the Presentation tab of the properties window you need to check the option Wrap Cell Text and set Cell Height to 2 lines. And make sure you put the Sales and Profit text in single quotes. Something like ='Sales: ' & sum(sales) & chr(13) & 'Profit: ' & sum(profit)

Re: New line character

sankar_ganesh — Wed, 13 Mar 2013 13:44:58 GMT

Hi Gysbert,

thanks for your answer. but in Ajax mode, wrap cell text is not working in QV 11.0 version, which is a bug ,and fixed in QV 11.2 SR1

Re: New line character

agigliotti — Fri, 17 May 2013 13:50:18 GMT

in the title text on the Caption tab multiline does works in v11.2 SR1 but in container on general tab -> Label for selected object the multiline works only with IE Plugin no with Ajax.

I hope it will be fixed in v11.2 SR2 !