topic Re: Number formatting in QlikView

Number formatting

Tue, 11 Nov 2014 10:09:32 GMT

can any suggest me how to format numbers

for ex:- i have 45.5643678541315

I just want to round up to 3 decimal after .

like 45.564

I tried this expression =Sum((vAnnualusage), '##.##0')

Re: Number formatting

MK_QSL — Tue, 11 Nov 2014 10:11:18 GMT

Num(YourFieldName,'#0.000') as YourFieldName

=NUM('45.5643678541315','#0.000')

=NUM(Sum((vAnnualusage),'#0.000'))

Re: Number formatting

anbu1984 — Tue, 11 Nov 2014 10:12:16 GMT

=Sum((vAnnualusage), '##.###')

Re: Number formatting

Tue, 11 Nov 2014 10:13:21 GMT

Hi ,

Try this ,

=num(sum(vAnnualusage),'##.###')

should work !!

Regards

Sahil

Re: Number formatting

MayilVahanan — Tue, 11 Nov 2014 10:14:16 GMT

Try like this

Num(Sum($(vAnnualusage)), '##.###')

Hope that vAnnualusage is the variable name.

Re: Number formatting

Tue, 11 Nov 2014 10:19:40 GMT

Hi,

Try like the following..

round(num(Sum($(vAnnualusage))), 0.001)

Hope it will work..

Re: Number formatting

Tue, 11 Nov 2014 10:22:11 GMT

Thanks Sahil it's work like a magic

Thanks

Amzad

Thank for Quick response Manish, anbu, Rama

Re: Number formatting

Tue, 11 Nov 2014 10:27:50 GMT

Yes shail it work SuperB, Thanks

Re: Number formatting

its_anandrjs — Tue, 11 Nov 2014 10:40:04 GMT

Hi,

You have to use Round function

=Round('45.5643678541315', 0.001 )

=Round( Sum(vAnnualusage), 0.001 )

Regards

Anand

Re: Number formatting

Tue, 11 Nov 2014 11:05:44 GMT

Thanks Anand, it's work..

Re: Number formatting

vardhancse — Tue, 11 Nov 2014 11:22:34 GMT

in properties->Number<Tab>->we can give the desired number format as well

Re: Number formatting

Tue, 11 Nov 2014 11:23:02 GMT

num(45.5643678541315,'#.000')

Re: Number formatting

Tue, 11 Nov 2014 11:36:30 GMT

Pls close the thread

Re: Number formatting

Tue, 11 Nov 2014 11:41:41 GMT

Hi,

properties->Number

Re: Number formatting

Tue, 11 Nov 2014 14:17:11 GMT

it's in Text Object sasi. Thanks tho

Re: Number formatting

Tue, 11 Nov 2014 15:15:38 GMT

ceil( 45.5643678541315,0.564)

floor(45.5643678541315,0.564)

Re: Number formatting

its_anandrjs — Tue, 11 Nov 2014 16:41:28 GMT

Hi Syed,

Close the thread by selecting appropriate correct or help full as answer i think there is lot of good responses.

Regards

Anand