Text Limitation

Mon, 06 Aug 2012 15:21:34 GMT

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.

Re: Text Limitation

rwunderlich — Mon, 06 Aug 2012 15:41:13 GMT

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

-Rob

Re: Text Limitation

Mon, 06 Aug 2012 15:43:12 GMT

Hi,

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

topic Re: Text Limitation in QlikView

Text Limitation

Re: Text Limitation

Re: Text Limitation