Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
t_hylander
New Contributor III

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
Contributor III

formatting number

Hi!

use NUM() Function.

=Num(Fieldname)

Hope this helps.

formatting number

Hi,

    Try this.

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

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

Regards,

Kaushik Solanki

t_hylander
New Contributor III

Re: formatting number

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
Contributor III

formatting number

Use:

Num(Result) as GVResult,

t_hylander
New Contributor III

Re: formatting number

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

formatting number

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

rahulgupta
Contributor III

formatting number

can u upload ur application.

t_hylander
New Contributor III

Re: formatting number

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
Contributor III

formatting number

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.

Community Browser