QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

Formatting functions

The formatting functions impose the display format on the input numeric fields or expressions, Depending on data type, you can specify the characters for the decimal separator, thousands separator, and so on.

The functions all return a dual value with both the string and the number value, but can be thought of as performing a number-to-string conversion. Dual() is a special case, but the other formatting functions take the numeric value of the input expression and generate a string representing the number.

In contrast, the interpretation functions do the opposite: they take string expressions and evaluate them as numbers, specifying the format of the resulting number.

The functions can be used both in data load scripts and chart expressions.

Note: For reasons of clarity, all number representations are given with a decimal point as the decimal separator.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?