Number Formatting in QlikSense

[Anonymous]

Hi Folks,

How to display numbers in Qlik where the output would be like this:

Input	Output
123.4567	123.4567
12.34	12.34
12.3	12.3
12	12

That is, I don't want trailing zeros after the least significant digit of the number.

Can someone please help me with the formatting required to achieve this.

Thanks in advance!

- Sukanya

[isingh30]

Try this  - #,#0 in format

[Anonymous]

You could fudge it by treating it as text and using string functions. maybe something like this :

Subfield([Input],'.',1)&If(Index([Input],'.'),'.'

&

Subfield([Input],'.',2))

[Anonymous]

Actually I have just had a fiddle and simply leaving the Number Formatting as Auto and using this seems to work.

num([Input])