topic Text getting truncated in App Development

Text getting truncated

PChristensen — Wed, 21 Jun 2023 22:01:04 GMT

Text is getting truncated! We have a table in our postgres data base with a text field. We are showing this text in a text and image chart in our apps, BUT now it seems Qlik automatically truncates the text during the load progress meaning that only half of the text is showing! How can we make it so Qlik does not truncate the text?

Re: Text getting truncated

Zapparoli — Thu, 22 Jun 2023 02:15:39 GMT

Hey PChristensen, does this happen only in the image and text chart ?

If you insert this field in a normal table or filter the same problem happens ?

Can you share a print screen please ?

- Matheus

Re: Text getting truncated

PChristensen — Thu, 22 Jun 2023 02:22:36 GMT

Hi Matheus

Did a bit of digging. It seems that it is something happening in the dark, so to speak, in the load of the data as the text never actually gets into the app without being truncated. I split my field in two <255 character lengths in the sql script and then within the text and image chart (and anywhere else) I just did field1 & field2 and things show fully that way. So it looks like a load script issue NOT a visualisation issue. I'd really prefer not having to split the text field just to put them together again.

Re: Text getting truncated

Zapparoli — Thu, 22 Jun 2023 02:33:45 GMT

I see, thanks for making this clear.

I have found this post in the community that seems to be related to your issue:

https://community.qlik.com/t5/QlikView-App-Dev/Loading-data-from-PostgreSQL-string-length-limit-exceeded/td-p/1827947

Can you check it out please ?

-Matheus

Re: Text getting truncated

Zapparoli — Thu, 22 Jun 2023 02:35:28 GMT

This may also help you:

https://community.qlik.com/t5/App-Development/DATABASE-LOAD-CHANGES-LENGTH-WHEN-SWITCHING-TO-MEMORY-POSTGRESQL/td-p/2025498

Re: Text getting truncated

PChristensen — Thu, 22 Jun 2023 20:08:58 GMT

Thank you Matheus

I changed the data type in the data base to varchar(1000) instead of text and it brought all the text in without truncating it.