How do you keep Character Return/Hard Returns When you Export to Excel?

patbuchanan — Thu, 07 May 2015 14:06:53 GMT

I've built a pivot table and my formatting looks great in Qlikview but i'm being asked to deliver the report in Excel and when I export to Excel it loses my formatting for my character/hard returns. I've got multiple fields I'm combining and I need each field to be on a separate line and I've tried chr(10), chr(13) & chr(9) and none of them keep the formatting when I export to Excel.

Below is a sample of my formula:

=Text(FSScheduleID & chr(10) & EventTitle & chr(10) & '('& EventStartDayofWeek & '-' & EventEndDayofWeek & ' ' & EventTime & ')' & chr(10)) & Concat(Distinct RoomDescription, ' : ')

Looks right in Qlikview:

Export to Excel and loose my formatting:

Re: How do you keep Character Return/Hard Returns When you Export to Excel?

Anonymous — Fri, 08 May 2015 15:21:28 GMT

The alignment in the Excel cells needs to be set to wrap text.

topic How do you keep Character Return/Hard Returns When you Export to Excel? in QlikView

How do you keep Character Return/Hard Returns When you Export to Excel?

Re: How do you keep Character Return/Hard Returns When you Export to Excel?