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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
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 )