Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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.