Skip to main content

Document Properties: Number

This property tab provides number formatting settings for all fields and variables of the document.

The list on the left is set to display either the Fields or the Variables of the document.

The Field Options group is only used for Fields:

The Default from Input button sets the formatting to that of the input.

Check the Survive Reload option if the formatting is to apply to the document permanently.

The following controls for formatting values are available:

Document Number properties
Property Description
Mixed Both numbers and text. Numbers shown in original format.
Number Shows numeric values with the number of digits set in the Precision spinner box.
Integer Shows numeric values as integers.
Fixed to Shows numeric values as decimal values with the number of decimal digits set in the Decimals spinner box.
Money Shows numeric values in the format shown in the Preview text box. The default format is the Windows Currency setting.
Date Shows values that can be interpreted as dates in the format set in the Format Pattern edit box. An example of this format is shown in the Preview text box.
Time Shows values that can be interpreted as time in the format set in the Format Pattern edit box. An example of this format is shown in the Preview text box.
Timestamp Shows values that can be interpreted as date + time in the format set in the Format Pattern edit box. An example of this format is shown in the Preview text box.
Interval Shows time as sequential time increment (e.g. format = mm shows the value as the number of minutes since calendar start ( 1899:12:30:24:00).

The Show in Percent (%) button operates on the following formats: Number, Integer and Fixed to.

Decimal and Thousand separators can be set in the edit boxes of the Separators group.

The ISO button uses the ISO standard to format date, time and timestamp values.

The System button uses the system settings for the formatting.

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!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com