topic formatting number in QlikView

formatting number

t_hylander — Thu, 11 Aug 2011 08:15:54 GMT

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!

formatting number

rahulgupta — Thu, 11 Aug 2011 08:20:15 GMT

Hi!

use NUM() Function.

=Num(Fieldname)

Hope this helps.

formatting number

kaushiknsolanki — Thu, 11 Aug 2011 09:14:59 GMT

Hi,

Try this.

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

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

Regards,

Kaushik Solanki

Re: formatting number

t_hylander — Thu, 11 Aug 2011 09:56:34 GMT

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

formatting number

rahulgupta — Thu, 11 Aug 2011 09:58:35 GMT

Use:

Num(Result) as GVResult,

Re: formatting number

t_hylander — Thu, 11 Aug 2011 10:02:28 GMT

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

kaushiknsolanki — Thu, 11 Aug 2011 10:03:34 GMT

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

formatting number

rahulgupta — Thu, 11 Aug 2011 10:29:21 GMT

can u upload ur application.

Re: formatting number

t_hylander — Thu, 11 Aug 2011 10:43:16 GMT

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.

formatting number

rahulgupta — Thu, 11 Aug 2011 10:49:09 GMT

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.

Re: formatting number

t_hylander — Thu, 11 Aug 2011 13:57:47 GMT

you were partly right

I didnt expanded it enough when I tested it earlier.

BUT it didnt help much because the numbers look like this now (its a straight table).

0,000.0000000000 (using Num(Result,'#,##0.0000000000')

and 4,6e-005 without format.

formatting number

rahulgupta — Wed, 17 Aug 2011 04:41:26 GMT

hi!

upload a sample app. in English.

formatting number

thanomjit — Wed, 17 Aug 2011 06:33:37 GMT

Please , try

=num(0.00046)/if(Len(Right(0.00046*10000,index(0.00046*10000,'.')-1))=1,10,1) result 4.6 E-005

=num(0.0004)/if(Len(Right(0.0004*10000,index(0.0004*10000,'.')-1))=1,10,1) result 0.0004

Re: formatting number

thanomjit — Wed, 17 Aug 2011 06:34:59 GMT

Please , try

=num(0.00046)/if(Len(Right(0.00046*10000,index(0.00046*10000,'.')-1))=1,10,1) result 4.6 E-005

=num(0.0004)/if(Len(Right(0.0004*10000,index(0.0004*10000,'.')-1))=1,10,1) result 0.0004