topic only 2 digits after decimal point. in QlikView

only 2 digits after decimal point.

Wed, 20 Jul 2011 09:28:52 GMT

Hi ,

In list box, i written an expression i.e; =Count(DefectName)/Count(TOTAL DefectName))*100

it getting the value like this 31.8012658925 , but i want to display only 2 digits after decimal point. i.e; 31.80.

How can i solve this.

Thanks

only 2 digits after decimal point.

raghavsurya — Wed, 20 Jul 2011 09:45:18 GMT

Hi,

Try this expression.

=num(Count(DefectName)/Count(TOTAL DefectName))*100,'#.##%')

Regards,

Raghav

only 2 digits after decimal point.

rahulgupta — Wed, 20 Jul 2011 09:46:44 GMT

Hey Hi,

Use Num() Function available,

In your case:

num(Count(DefectName)/Count(TOTAL DefectName))*100,'#,##.00')

Hope this helps

Regards

Re: only 2 digits after decimal point.

martin59 — Wed, 20 Jul 2011 09:48:30 GMT

Hi,

You have to do something like this :

num(Count(DefectName)/Count(TOTAL DefectName))*100,'# ###.##%', '.', ' ')

num() function parameters :

num(Number, Format, Decimal Sep, Thousand Sep)

Hope that helps you

Martin

Re: only 2 digits after decimal point.

Wed, 20 Jul 2011 10:01:43 GMT

Hi,

Goto listbox properties->Number tab-> Select Override Document Settings to enable the properties below and then select Fixed To - 2 decimals. That should suffice.

Thanks.

Re: only 2 digits after decimal point.

Wed, 20 Jul 2011 10:02:14 GMT

Hi,

Goto listbox properties->Number tab-> Select Override Document Settings to enable the properties below and then select Fixed To - 2 decimals. That should suffice.

Thanks.