
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Max length of a field in Qlikview
Hello
does anyone know what the maximal field length is in Qlikview?
thx
Cheers
F.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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. 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. 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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Solomon,
sorry if I was not clear i meant: the content of a field.
Thx anyway 🙂
cheers
F.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;
