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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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"