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