Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ssett249
New Contributor

Number Formatting in QlikSense

Hi Folks,

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

InputOutput
123.4567123.4567
12.3412.34
12.312.3
1212

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

3 Replies
isingh30
Contributor III

Re: Number Formatting in QlikSense

Try this  - #,#0 in format

Re: Number Formatting in QlikSense

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))

Re: Number Formatting in QlikSense

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

num([Input])