Skip to main content

QvxFieldHeader element

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.

Elements

Child Element

Description

FieldName

Field name.

Type

Data type in which field values are written in the QVX formatted data stream.

QvxFieldType type.

Extent

Method used to define field value length.

QvxFieldExtent type.

NullRepresentation

Method used to handle Null values.

QvxNullRepresentation type.

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:

  • 1,2,4 or 8 for QVX_INTEGER_SIGNED and QVX_UNSIGNED_INTEGER.
  • 4 or 8 for QVX_IEEE_REAL.
  • Arbitrary size for other QVX field types.

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.

FieldAttributes type.

 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!