Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Dan72
Contributor II
Contributor II

Qlik not recognising carriage returns (line breaks) in Google Sheets cells

Hello, I have a problem with Qlik not recognising carriage returns within a Google sheet cell, it worked perfectly on a previous version of my app deployed about ~2 weeks ago, but now I am creating an updated version it is displaying these text fields on a single contiguous line (i.e. not recognising the carriage returns in the cell), this is despite the fact that none of the underlying data has changed in the meantime (but I have changed some column names in the underlying sheet and then remapped them in the load script - but I don't see why this would impact). Any help or suggestions on where the problem may be much appreciated?

Labels (1)
1 Solution

Accepted Solutions
Dan72
Contributor II
Contributor II
Author

Hello Rafaelencinas, 

Many thanks for your reply, in-fact this was just a text-field, not a Table, but I did find the source of the problem, a colleague had implemented a clean function on the source data for other reason, but this had downstream impact on the Qlik data, but it was a good lessons learned for me. Thanks once again however for taking the time to reply. 

Regards

Dan

View solution in original post

3 Replies
rafaelencinas
Partner - Creator II
Partner - Creator II

Hi !

Check if you option in Table "Wrap Text in Cells" are unchecked.

I tested your request and if this option is Enabled, the carriage works fine, if disabled, it does't work.

 

Bye!

 

Senior Qlik Architect
Cobra, Stallone, "You're a problem and I'm the solution"
Dan72
Contributor II
Contributor II
Author

Hello Rafaelencinas, 

Many thanks for your reply, in-fact this was just a text-field, not a Table, but I did find the source of the problem, a colleague had implemented a clean function on the source data for other reason, but this had downstream impact on the Qlik data, but it was a good lessons learned for me. Thanks once again however for taking the time to reply. 

Regards

Dan

rafaelencinas
Partner - Creator II
Partner - Creator II

Would you like to share an image to help us to see the problem?

Bye!

Senior Qlik Architect
Cobra, Stallone, "You're a problem and I'm the solution"