5 Replies Latest reply: Jul 19, 2015 5:09 AM by Sahir Ahmed RSS

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

      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