topic Display Value in Text Object with 2 digit after decimal point in QlikView

Display Value in Text Object with 2 digit after decimal point

Anonymous — Tue, 24 Mar 2015 10:24:27 GMT

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

Anonymous — Tue, 24 Mar 2015 10:27:14 GMT

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

sagarkharpude — Tue, 24 Mar 2015 10:27:29 GMT

Try this

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

Anonymous — Tue, 24 Mar 2015 10:27:57 GMT

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