Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

How to reduce decimal places on format pattern

I have a value of £1,000,000,000,000 I want this down to £1,000B or similar.

Any help would be good.

1 Solution

Accepted Solutions
Employee
Employee

Re: How to reduce decimal places on format pattern

You would need to divide the value by 1000000000  (one billion) and then use a format mask with a B on the end.

Untitled.png

1 Reply
Employee
Employee

Re: How to reduce decimal places on format pattern

You would need to divide the value by 1000000000  (one billion) and then use a format mask with a B on the end.

Untitled.png

Community Browser