Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sankar_ganesh
New Contributor

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

Re: New line character

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
3 Replies

Re: New line character

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
New Contributor

Re: New line character

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
Honored Contributor II

Re: New line character

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 !

Community Browser