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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text Limitation

Hi,

I am new to Qlikview.  However I have loaded data from a database using an ODBC connection.  I then created a text box and set a code up so all information from a text field within the database went into the textbox (the text was taken from a field called prob_text) .  However I noticed that it only shows as a certain amount of characters.

Thefore just before my SQL Statement, I added in the following:

LOAD * text (prob_text). 

This seemed to add a bit more data into the text box, but not enough.  I was wondering if there is a way I can set my above Statement before my SQL to add more than 255 characters to a text field.

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

This is usually a driver setting. What database and driver are you uisng?

-Rob

Not applicable
Author

Hi,

I am not sure what database I am using, however the driver for the ODBC connection is: MYSQL ODBC 3.51 Driver.