topic Re: Number Formatting in expression level in QlikView

Number Formatting in expression level

Anonymous — Tue, 26 Aug 2014 07:05:46 GMT

Hi Guru's

I want to Format My output Number Up to 3 Decimals

EX: Num(((5/10/33,'#.##', '.',',' )

5/10/33=0.015

if i use like this Num(((5/10/33,'#.##', '.',',' )

it showing 0.01

So, i need to show one more decimal in output

Ans:0.015

thanks in advance

Re: Number Formatting in expression level

senpradip007 — Tue, 26 Aug 2014 07:08:47 GMT

Try like:

Num(5/10/33,'#.###', '.',',' )

Re: Number Formatting in expression level

tresB — Tue, 26 Aug 2014 07:09:29 GMT

Try:

=Num(number, '#,##0.000' )

Re: Number Formatting in expression level

Anonymous — Tue, 26 Aug 2014 07:11:20 GMT

Hello,

try this one:

Num(((5/10/33,'#.###')

Re: Number Formatting in expression level

jagan — Tue, 26 Aug 2014 07:12:20 GMT

Hi Babu,

For 3 digits you have to give 3 zeros after '.'

Num(5/10/33,'#,##0.000')

Regards,

Jagan.

Re: Number Formatting in expression level

Anonymous — Tue, 26 Aug 2014 07:23:29 GMT

Hi Guys ,

I tried all ur Suggestions.It showing 0.005

i need 0.015

I got required number 0.015

explanation: num(num(field1/field2,'0.000')/

num((field3)-field4),'0.000),'0.000)

field1=5

field2=10

field3-field4=33

Note:Iam not using environmental variables in applicatio

Thanks guys.

Re: Number Formatting in expression level

senpradip007 — Tue, 26 Aug 2014 07:26:50 GMT

Hi Babu,

I've tried and its working fine with Num(5/10/33, '#.###') this expression.

Re: Number Formatting in expression level

jagan — Tue, 26 Aug 2014 07:36:50 GMT

Hi Babu,

This Num(5/10/33,'#,##0.000') is working as expected and returning 0.015, if you want 0.01 then use Num(5/10/33,'#,##0.00').

Hope this helps you.

Regards,

Jagan.

Re: Number Formatting in expression level

jagan — Thu, 28 Aug 2014 06:07:11 GMT

Hi Babu,

Please close this thread if you got the required solution.

Regards,

Jagan.