Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this - #,#0 in format
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))
Actually I have just had a fiddle and simply leaving the Number Formatting as Auto and using this seems to work.
num([Input])