topic Re: 2 Decimal Points in QlikView

2 Decimal Points

Thu, 21 Aug 2014 06:00:31 GMT

Hi,

I have used 2 textboxes .

1.With text as density

2.with value

In 2nd textbox,i want to display only 18.56. If i use round,it'll round to 18.

I want two decimal digits to display. Can somebody help me?

Regards,

Shruthi

Thu, 21 Aug 2014 06:02:47 GMT

Hi,

Use this function

NUM(Value,'#,##0.00')

Thanks and Regards,

Vivek

er_mohit — Thu, 21 Aug 2014 06:06:07 GMT

Try to use num function with your expression

suppose i have sum(Value)= 18.5678

try this in text object

=num(sum(Value),'#.##0,00')

Anonymous — Thu, 21 Aug 2014 06:19:53 GMT

Hi,

Try this one.

=NUM(sum(Value),'#.00')