Text getting truncated

[PChristensen]

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?

[Zapparoli]

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

[PChristensen]

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.

[Zapparoli]

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-exce...

Can you check it out please ?

-Matheus

[Zapparoli · Accepted solution]

This may also help you:

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

[PChristensen]

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.