Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
patbuchanan
Contributor III
Contributor III

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

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:

Qlivew.JPG

Export to Excel and loose my formatting:

Excel.JPG

1 Solution

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

1 Reply
Anonymous
Not applicable

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