Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max length of a field in Qlikview

Hello

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

thx

Cheers

F.

4 Replies
soloeeeoff
Contributor III
Contributor III

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
Specialist II
Specialist II

Hello,

i think there is no Limit in QlikView.

See also

Maximum characters per field

Not applicable
Author

Hi Solomon,

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

Thx anyway 🙂

cheers

F.

Peter_Cammaert
Partner
Partner

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.