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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.