Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New 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
Highlighted
New Contributor III

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

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

View solution in original post

1 Reply
Highlighted
New Contributor III

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

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

View solution in original post