Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sankar_ganesh
Partner
Partner

New line character

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.

CountryResults
xxxSales: 1000
Profit : 150
yyySales: 2000
Profit : 550
zzzSales: 3000
Profit : 1500

Thanks.,

Sankar

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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)


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

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)


talk is cheap, supply exceeds demand
sankar_ganesh
Partner
Partner
Author

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

agigliotti
Partner
Partner

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 !