Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

OmarBenSalem
Esteemed Contributor

Format a number like this '2.3758 E-5' to as simple number (example 0.034?)

Hi guys ( stalwar1 )

I have a field like this:

Capture.PNG

I was wondering, how can I format it as a number? withou the E thing?

Thanks

1 Solution

Accepted Solutions
surendraj
Valued Contributor

Re: Format a number like this '2.3758 E-5' to as simple number (example 0.034?)

May be this!!

=Num('2.3782E-5', '(dec)')

8 Replies

Re: Format a number like this '2.3758 E-5' to as simple number (example 0.034?)

Something like this

=Num(2.3782E-5, '0.000000')

=Num(FieldName, '0.000000')

OmarBenSalem
Esteemed Contributor

Re: Format a number like this '2.3758 E-5' to as simple number (example 0.034?)

When I do this, here's what happens:

Capture.PNG

Re: Format a number like this '2.3758 E-5' to as simple number (example 0.034?)

Might need to add more 0s (=Num(2.3782E-5, '0.000000000'))... not sure but I see this, when I use this in text box object

Capture.PNG

OmarBenSalem
Esteemed Contributor

Re: Format a number like this '2.3758 E-5' to as simple number (example 0.034?)

even with a lot of 0.0000000000000000 that does not seem to work

Capture.PNG

surendraj
Valued Contributor

Re: Format a number like this '2.3758 E-5' to as simple number (example 0.034?)

May be this!!

=Num('2.3782E-5', '(dec)')

OmarBenSalem
Esteemed Contributor

Re: Format a number like this '2.3758 E-5' to as simple number (example 0.034?)

That's the first time I see this !

Great Surendra !!

Re: Format a number like this '2.3758 E-5' to as simple number (example 0.034?)

Me too ... Well I have seen this before, but never used it to know how it works

surendraj
Valued Contributor

Re: Format a number like this '2.3758 E-5' to as simple number (example 0.034?)

Community Browser