topic Re: Multi Line Caption in Straight or Pivot Chart in QlikView

Multi Line Caption in Straight or Pivot Chart

Fri, 24 May 2013 15:33:59 GMT

Hi all,

Wrap does not work! How to create multi line caption as below:

=[Branch Name]

='Profit and Loss'

='For the period ended '&Month&' '&Year

thanks in advance!

BR,

SAK

Gysbert_Wassenaar — Fri, 24 May 2013 15:38:56 GMT

Try

=[Branch Name] & chr(10) & 'Profit and Loss' & chr(10) and 'For the period ended '&Month&' '&Year

Don't forget to enable the Wrap Text option on the Caption tab of the properties window and set the Caption Height to 3 lines.

juleshartley — Fri, 24 May 2013 15:42:09 GMT

Have you tried chr(10)

eg.

=[Branch Name] & chr(10) &

'Profit and Loss' & chr(10) &

'For the period ended '&Month&' '&Year

Fri, 24 May 2013 16:34:46 GMT

But to how to export this caption to excel along with the chart.

Gysbert_Wassenaar — Fri, 24 May 2013 16:40:36 GMT

That's only possible with a macro. See here for an example.

Sat, 25 May 2013 08:52:13 GMT

Thanks! so these are ASCII codes