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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
dbaksa_1
Partner - Creator
Partner - Creator

File Size Limitation

Can anyone tell me if there is a limit to the number of characters that a QlikView field can hold. I'm having a problem with data being truncated and I believe it may be the source output truncating the data and not QlikView.

Thanks in Advance,

Dan

Labels (1)
1 Solution

Accepted Solutions
dbaksa_1
Partner - Creator
Partner - Creator
Author

Tom,

Thanks for the quick reply. We have isolated it to an ODBC issue. We were however curious if there was a limitation.

Thanks and have a great New Year!

View solution in original post

2 Replies
Not applicable

QlikView does not impose a limit on the number of characters in a field - but in some cases there is actually a limit in ODBC of 1023 chars. Try putting the data in to a text file and see if it pulls in the correct number. OLE DB may work better here than ODBC.

Tom

dbaksa_1
Partner - Creator
Partner - Creator
Author

Tom,

Thanks for the quick reply. We have isolated it to an ODBC issue. We were however curious if there was a limitation.

Thanks and have a great New Year!