topic Is there a string limit displaying data in QlikView

Is there a string limit displaying data

Wed, 17 Mar 2010 20:20:55 GMT

I have a qlikview application that is loading from an MS SQL table with a column that is of type varchar(MAX). This data contains large amounts of text that will be used as documentation.

When loading this into Qlikview and displaying in a text object, the data will be cut off as if there is a limit in the amount of string data that Qlikview can present and/or read for a field of data.

Can anyone verify that there is indeed a limit or if it may be some other oddity in my application.

Is there a string limit displaying data

Wed, 17 Mar 2010 21:10:23 GMT

Hi,

if I am not mistaken, there is no limitation for text object its all about size but you can set a limit on charts for your dimension from "properties>presentation" except straight , pivot and gauge...

Best Regards,

Onder ALTINBILEK

Is there a string limit displaying data

Wed, 17 Mar 2010 21:21:47 GMT

Turns out that QlikView doesn't recognize an MS SQL datatype of varchar(MAX). I changed it to varchar(8000) and I get all the data to load through the script.