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: 
arieidel
Partner - Creator II
Partner - Creator II

How to extend the limit of a text field?

Hello,

I'm trying to read data from an Excel sheet that has a column which free text, some of them are quite long -around 800 chars. When I see it in the qvw it shows incomplete: only the first 500 chars are shown.

It seems to be a limit for the text a QlikView field could store. Do you know how to extend it o a workaround just to get the complete text of those long comments?

Thanks,

Ariel

1 Solution

Accepted Solutions
arieidel
Partner - Creator II
Partner - Creator II
Author

First of all, thanks for your answers.

I was just creating an example of this, in order to show you the problem, and the thing is that you were right! There is no such limit with the text in the field. The limit exists only in the tooltip of the value and only in AJAX. The tooltip using IE plugin (or in QV Desktop) shows the full text.

I'm attaching images to show this behaviour.

Anyway, I'm glad that my text will not be cut. It is just the tooltip in AJAX.

Thanks again,

Ariel

View solution in original post

3 Replies
Not applicable

Hello,

Explain more your problem, cause I've make a test and the qvw show all the size of the text.

When your load a Excel file the QlikView read the all the string?

Do you have specified something differente?

marcus_sommer

I'm not sure whether there are such limits - rather not - and definetely not by a few hundred chars. I have already loaded (from excel) fields with several thousand chars and could them display within textboxes and pivots. Therefore your issue must have another reasons. What result do you have by:

...

len(Field) as FieldLen

....

- Marcus

arieidel
Partner - Creator II
Partner - Creator II
Author

First of all, thanks for your answers.

I was just creating an example of this, in order to show you the problem, and the thing is that you were right! There is no such limit with the text in the field. The limit exists only in the tooltip of the value and only in AJAX. The tooltip using IE plugin (or in QV Desktop) shows the full text.

I'm attaching images to show this behaviour.

Anyway, I'm glad that my text will not be cut. It is just the tooltip in AJAX.

Thanks again,

Ariel