Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Sahir, Can you try with
& chr(13) & chr(10) &
Hi Piet Hein,
I tried that too, unfortunately it doesn't work
Thanks!
Sahir
It doesn't work for me too. Anyone else knows how to get this done?
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
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