Display 3 Decimal Places Without Rounding in KPI/Object

[DP99]

Hi everyone,

I have a KPI that returns a percentage value. The actual value is:

99.999959%

My requirement is to display only 3 digits after the decimal point, but without rounding the value.

Currently, when I use a format pattern such as:

#,##0.000%

Qlik rounds the value and displays:

100.000%

To avoid the rounding, I am currently using:

#,##0.000000%

which displays the actual value as:

99.999959%

However, I only want to show 3 decimal places, resulting in:

99.999%

(not 100.000%).

Is there any way in Qlik Sense to truncate the decimal places instead of rounding them when formatting a percentage value?

Any suggestions would be appreciated. Thanks!

[vighnesh_gawad · Accepted solution]

Hi @DP99 ,

Try this expression. It truncates value rather than rounding it off.

Num(Floor(YourField * 100000) / 100000, '#,##0.000%')

[DP99]

thankyou so much, it worked