Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
t_hylander
Creator
Creator

formatting number

Ive got a couple of numbers ranging from 0.1 to 0.00001 in a excel-file. They are not formatted as numbers (due to the range).

I dont  want the numbers to with a fixed format (0.10000 to 0.00001).

How can I deal with this in QW?

It works now with 4 decimals but with 5 it shows 4,6e-005 (0.00046).

Thanks in advance!

13 Replies
rahulgupta
Partner - Creator III
Partner - Creator III

Hi!

use NUM() Function.

=Num(Fieldname)

Hope this helps.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Try this.

    Num(Field_Name,'#,##0.0000000000')

    This will allow you to show 10 digits after decimal point.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
t_hylander
Creator
Creator
Author

Forgot to say that Ive tested both Num() and Num# but both generates a error when I load.

Not sure of the english translation but something about "Trash-code after section".

the line looks like this;

Result as Num(GVResult),

the same with Solanki's tips...

rahulgupta
Partner - Creator III
Partner - Creator III

Use:

Num(Result) as GVResult,

t_hylander
Creator
Creator
Author

duh, ofcourse..

Still doesnt help all the way tho.

With just the Num(Result) as GVResult I got no change at all

With the formatting I just gets ##### instead of numbers...

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   If you are using this in Script then you must use in this fasion.

  Num(Field_Name,'#,##0.0000000000')  as Field_Name

   If you want to use in dimension then just use.

 

   Num(Field_Name,'#,##0.0000000000')

   If you want to use in chart then you must go to properties-> number -> and click on expression and click on Fixed to . Here type 10.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
rahulgupta
Partner - Creator III
Partner - Creator III

can u upload ur application.

t_hylander
Creator
Creator
Author

Solanki: I tried both and if I just Fixed to All the numbers got 10 decimals (I only want the ones that needs it to have 10 decimals)

Gupta: Sorry, dont think it would help since its not in english

But its strange that there seem to be a limit with 5 decimals...4 shows OK even without Num()-function.

rahulgupta
Partner - Creator III
Partner - Creator III

i want to knw where r u using this field.

if u r using it in pivot or straight table then expand the column containing this field.....becz #### is normally shown when the number contains many digits and thy don't fit in the column.so Expand ur column.