The QvxFieldHeader element describes a single table field. It specifies the field name, format used to write the field values in the QVX formatted file, as well as how QlikView or Qlik Sense should interpret the values.
The elements Type, Extent, NullRepresentation, BigEndian, CodePage and ByteWidth describe how the field data values are written in the QVX formatted file.
FixPointDecimals and FieldFormat can be used to specify for QlikView and Qlik Sense how to interpret the read data values.
|
Child Element |
Description |
|---|---|
|
FieldName |
Field name. |
|
Type |
Data type in which field values are written in the QVX formatted data stream. |
|
Extent |
Method used to define field value length. |
|
NullRepresentation |
Method used to handle Null values. |
|
BigEndian |
Order of bytes (with respect to significance) in data stream. It may be used for binary fields, that is, QVX_SIGNED_INTEGER, QVX_UNSIGNED_INTEGER and QVX_REAL, also it may be used for byte count in QVX_COUNTED fields. If not specified LittleEndian is assumed. |
|
CodePage |
Character encoding used to write field values in the QVX data stream. 1200/1201 implies UTF16. Byte order mark (BOM) is not allowed. BigEndian has no effect on UTF16. If not set then UTF8 is assumed. |
|
ByteWidth |
In case of QVX_FIX fields, it is a size of the actual data:
In case of QVX_COUNTED fields, it is a size of the byte count value, which is used to store a size of the actual data. |
|
FixPointDecimals |
Fixed number of digits to the right of the radix point. Used together with QVX_SIGNED_INTEGER, QVX_UNSIGNED_INTEGER, QVX_PACKED_BCD. For instance, value 1234 is interpreted as 12.34 with FixPointDecimals = 2 and is interpreted as 123400 with FixPointDecimals = -2. |
|
FieldFormat |
Format specifies how QlikView or Qlik Sense should interpret the streamed data values. |