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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display Value in Text Object with 2 digit after decimal point

Hi All,

I've Gauge chart and using Digital number value like 22.45.Now i want to display the same value in text box instead of 
digital number.

I tried with text object but it showing value like 22.43273761.I want display only 2 digit after decimal point.

My expression is :

=(sum(if(BG_STATUS='Rejected',1,0))/count(BG_BUG_ID))*100

3 Replies
Anonymous
Not applicable
Author


num((sum(if(BG_STATUS='Rejected',1,0))/count(BG_BUG_ID))*100 ,'##.##')

sagarkharpude
Creator III
Creator III

Try this


num(((sum(if(BG_STATUS='Rejected',1,0))/count(BG_BUG_ID))*100),'#,##')

Anonymous
Not applicable
Author

=round ( (sum(if(BG_STATUS='Rejected',1,0))/count(BG_BUG_ID))*100 , 0.01 )