topic Re: Num function digits after the comma in QlikView

Num function digits after the comma

ez — Tue, 04 Feb 2020 12:56:30 GMT

Hello,

I have to format an expression into an expression with 2,3 or 4 digits after the comma:

1335,1 - 1.335,10

1335,14 - 1.335,14

1335,145 - 1.335,145

1335,1456 - 1.335,1456

1335,14567- 1.335,1457

I tried

Num( 1335,1456, '#.##0,00##', ',' , '.' ),

but there is no difference to

Num( 1335,1456, '#.##0,0000', ',' , '.' ) .

Any suggestions?

Thank You

marcus_sommer — Wed, 05 Feb 2020 13:54:32 GMT

You could set the formatting explicitely depending on the number of digits. The following looked a bit ugly but it worked:

num(1335.1, '#.##0,' & repeat('#', rangemax(2, rangemin(len(subfield(1335.1, '.', 2)), 4))))

- Marcus

ez — Thu, 06 Feb 2020 07:13:36 GMT

Thank you Marcus,

it works.