How to extend the limit of a text field?

[arieidel]

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

[#2]

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 · Accepted solution]

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