Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

only 2 digits after decimal point.

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

5 Replies
raghavsurya
Partner - Specialist
Partner - Specialist

Hi,

Try this expression.

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

Regards,

Raghav

rahulgupta
Partner - Creator III
Partner - Creator III

Hey Hi,

Use Num() Function available,

In your case:

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

Hope this helps

Regards

martin59
Specialist II
Specialist II

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

Not applicable
Author

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.

Not applicable
Author

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.