topic Expression Labels in QlikView

Expression Labels

pkelly — Tue, 13 Jul 2010 14:15:47 GMT

Currently working on a pivot table...

The title for the column in the attached picture is made up from the following...

='£ : ' & varQuarter_Label & ' ' & varCurrentFinancialYear & ' - ' & varQuarter_Label & ' ' & varLastFinancialYear & ' GP'

What I want to show is....

£ : Q1 2010 -

Q1 2009 GP

Have tried mucking about with spacing between the '-' sign with noc success.

Is there anyway to force a new line at a certain point in the expression title?

disqr_rm — Tue, 13 Jul 2010 14:19:11 GMT

Try adding a carriage return chr(10) or chr(13) manually:

='£ : ' & varQuarter_Label & ' ' & varCurrentFinancialYear & ' - ' & chr(10) & varQuarter_Label & ' ' & varLastFinancialYear & ' GP'

pkelly — Tue, 13 Jul 2010 14:27:08 GMT

Many Thanks Rakesh - I was hoping it would be something straightforward like this...