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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. 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!

 

"Without data, you're just another person with an opinion." — W. Edwards Deming.
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!

"Without data, you're just another person with an opinion." — W. Edwards Deming.