Reputation: 525
I have a Qlik Sense chart with one Dimension and one measure. the numbers I got from the measure is (99,999861) I need a custom format pattern to have the numbers like 99,99 %.
Upvotes: 1
Views: 3658
Reputation: 484
Here's the syntax: https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Introduction/conventions-number-time-formats.htm
A few specifics from that page:
To denote a specific number of digits, use the symbol "0" for each digit.
To denote a possible digit to the left of the decimal point, use the symbol "#".
To mark the position of the thousands separator or the decimal separator, use the applicable thousands separator and the decimal separator.
Upvotes: 0
Reputation: 936
click edit, choose the chart, open the data tab, expand the measure, under number formatting select custom. Format pattern would be something like this.
#,##0.00%
Upvotes: 0