Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Max length of a field in Qlikview

Hello

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

thx

Cheers

F.

Tags (2)
4 Replies
Highlighted
soloeeeoff
New Contributor III

Re: Max length of a field in Qlikview

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
Valued Contributor

Re: Max length of a field in Qlikview

Hello,

i think there is no Limit in QlikView.

See also

Maximum characters per field

Not applicable

Re: Max length of a field in Qlikview

Hi Solomon,

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

Thx anyway 🙂

cheers

F.

Re: Max length of a field in Qlikview

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.