topic Re: Format a number in QlikView

Format a number

qvhjenvo — Mon, 28 Apr 2014 08:55:28 GMT

Hi,

I have a number for ex. 4,535910775293e-014

I want to format the number to for ex. 0,05. How?

Someone helps me!

Loi

Re: Format a number

MK_QSL — Mon, 28 Apr 2014 08:59:03 GMT

NUM(YourNUMBERField,'#,##0.00') as YourNUMBERField

Re: Format a number

qvhjenvo — Mon, 28 Apr 2014 09:22:54 GMT

Hi,

I have tried this in a textbox

NUM('4,53591077529e-014','###0.00')

It does not work.

Re: Format a number

MK_QSL — Mon, 28 Apr 2014 09:26:59 GMT

Try in your script...

How is your field of NUMBER ?

Re: Format a number

its_anandrjs — Mon, 28 Apr 2014 09:28:46 GMT

Try to write like

=Round ( NUM(4,535910775293e-014,'#,##0.00'),1,0.05)

Re: Format a number

MK_QSL — Mon, 28 Apr 2014 09:33:00 GMT

Try

=NUM(SubField('453591077529e-014','e',1)*pow(10,LEFT(SUBFIELD(453591077529e-014,'e',2),1)&Right(453591077529e-014,2)),'#,##0.000')

Re: Format a number

rbecher — Mon, 28 Apr 2014 09:40:22 GMT

Do you mean 4,535910775293e-14? This would be a very small number..

Re: Format a number

rbecher — Mon, 28 Apr 2014 09:46:40 GMT

This shows a decimal value:

=Num(Num#('4.535910775293e-14'),'#,000000000000000',',','.')

Re: Format a number

maxgro — Mon, 28 Apr 2014 09:55:53 GMT

num(

subfield(upper(4.535910775293e-014),'E',1)

pow(10, subfield(upper(4.535910775293e-014),'E',2))

,'#,##0.000000000000000')

I added some 0 to format, your number is so small .....

Re: Format a number

qvhjenvo — Mon, 28 Apr 2014 10:33:00 GMT

Hi,

Want to post an attachment. So u can see better

But I can not see how to post the attachment.

Re: Format a number

MK_QSL — Mon, 28 Apr 2014 10:35:43 GMT

Click on Use Advance Editor (Right TOP) where we are replying....!

Now you can find Attach (Right Bottom)

Re: Format a number

its_anandrjs — Mon, 28 Apr 2014 10:35:56 GMT

Use advance editor for that.

Re: Re: Format a number

qvhjenvo — Mon, 28 Apr 2014 11:01:38 GMT

Ok. Thanks

In the attachement there are 3 textbox with different formats.

Result in the last one is desired.

The first textbox is what I want to format directly so that I have as the result in the last txtbox.

Re: Format a number

MK_QSL — Mon, 28 Apr 2014 11:16:01 GMT

=NUM($(expUSDEksponeringTeller)/$(expBeløpNyePoliser)*POW(10,12),'#,##')

Update :

=NUM($(expUSDEksponeringTeller)/$(expBeløpNyePoliser)*POW(10,RIGHT(SubField($(expUSDEksponeringTeller)/$(expBeløpNyePoliser),'e',2),2)-1),'#,##')

Re: Re: Format a number

qvhjenvo — Mon, 28 Apr 2014 11:48:25 GMT

Thanks. U saved my day!!!

Re: Format a number

Wed, 20 Aug 2014 18:43:12 GMT

Hi Loi Tan Vo,

There is yet another way of making, using integers only might use a Num(Field, '########################').

Hope that helps.

I left an example here Campo numérico com mais de 14 caracteres

hugs