Max length of a field in Qlikview

[#1]

Hello

does anyone know what the maximal field length is in Qlikview?

thx

Cheers

F.

[soloeeeoff]

Hi Felix,

For table name A maximum of 32 characters is used.

I wish to know if this be for Field name also.

Documentation :

Tables are named according to the following rules:

1. 1. If a label immediately precedes a load or select statement the label will be used as table name. The label must be followed by a colon .
2. 2. If no label is given, the filename or table name immediately following the keyword from in the load or select statement is used. A maximum of 32 characters is used. For filenames the extension is skipped.

[zhadrakas]

Hello,

i think there is no Limit in QlikView.

See also

Maximum characters per field

[#4]

Hi Solomon,

sorry if I was not clear i meant: the content of a field.

Thx anyway 🙂

cheers

F.

[Peter_Cammaert]

IMHO there is no theoretical limit to the length of the string part of a field value.

However, I ran into trouble more than once when creating text keys longer than, say, 80000 characters. So my advice would be to never exaggerate and switch to AutoNumber/AutoHashXXX translations as soon as possible. Especially whenever the cardinality of your field is high.

Problems with this part of the QlikView kitchen are extremely difficult to trace.

[jonashertz]

Late and nerdy reply but I stumbled upon this and got interested.

65536 seems to be the magic number, that is the maximum characters you can put in a field (on the same row). But this is the case for 1 byte sized characters.  If you put something fancier (like emojis) in the string Qlik might change the field type under the hood from char to unicode and then only 1/4 as many characters can fit (16384).

As a side note 65536 also relates to the maximum distinct values we can have in QlikView/Sense:  2,147,483,648

Try it!

maxunicode:
load
Repeat(Chr(128077),16384) as long_unicode
AutoGenerate 1;

maxchar:
load
Repeat('a',65536) as long_char
AutoGenerate 1;