topic qlik Sense newline in subtitle chr(13) does not work in App Development

qlik Sense newline in subtitle chr(13) does not work

Sat, 16 Nov 2024 11:08:21 GMT

Hi guys,

Im trying to write out two expressions in the subtitle of a barchart as:

'CAGR FIRST PERIOD: 1,21%'

'CAGR LAST PERIOD: 1,23%'

i am using chr(13) for the new line but it only creates a space, chr(10) gives me the same, is it not possible to make a newline?

I GET:

'CAGR FIRST PERIOD: 1,2%' 'CAGR LAS

T PERIOD: 1,2%' ,

My expression for the subtitle is:

='CAGR LAST PERIOD: '&num(pow(Sum({$<Date={"$(=Date(Max(Date)- 28))"}>}Sales) / Sum({$<Date={"$(=Date(Max(Date) - 49))"}>}Sales), 1/3) - 1, '0,00%')&chr(13)&'CAGR LAST PERIOD: '&num(pow(Sum({$<Date={"$(=Date(Max(Date)))"}>}TARGET_PAY) / Sum({$<Date={"$(=Date(Max(Date) - 28))"}>}TARGET_PAY), 1/4) - 1, '0,00%')

Thanks!

Sahir

Re: qlik Sense newline in subtitle chr(13) does not work

stigchel — Fri, 17 Jul 2015 13:49:14 GMT

Hi Sahir, Can you try with

& chr(13) & chr(10) &

Re: qlik Sense newline in subtitle chr(13) does not work

Fri, 17 Jul 2015 14:02:43 GMT

Hi Piet Hein,

I tried that too, unfortunately it doesn't work

Thanks!

Sahir

Re: qlik Sense newline in subtitle chr(13) does not work

Fri, 17 Jul 2015 15:24:13 GMT

It doesn't work for me too. Anyone else knows how to get this done?

Re: qlik Sense newline in subtitle chr(13) does not work

Michael_Tarallo — Fri, 17 Jul 2015 18:03:53 GMT

Hello Sahir,

Subtitle and other header lines are limited to 1 line, and will only wrap at the end of the container.

HTH

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Re: qlik Sense newline in subtitle chr(13) does not work

Sun, 19 Jul 2015 09:09:36 GMT

Thanks Mike then I understand, but do you have any tip on how and where to print out some useful information about the charts? I have two CAGR values I want to print out in percent so the viewer can understand what the chart is about, and I need it done within the chart.

Kind regards,

Sahir