Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text In Chart - Removing Decimal Places

Hi,

I have learnt an awful lot through Google, QlikCommunity and Trial and Error over the past few days but there are a few issues that I just can not solve.

I know that there will be a simple solution to this, but I am trying to reduce some "Text in Chart" to 2 decimal places.

The base expression I have in the Text in Chart field is:

= Avg(CSAT)

This is taking the average of our Customer Satisfaction score. It currently returns 80.0000 for a particular client.

Please can somebody ease my frustration and let me know how to reduce this to 80.00 (two decimal places).

Many thanks,

Jonathan

1 Solution

Accepted Solutions
MayilVahanan

Hi,

     Try this,

     =Num(Avg(CSAT),'#,##0.00') or in Properties->Number->Fixed to give 2 decimal..

     Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

Hi,

     Try this,

     =Num(Avg(CSAT),'#,##0.00') or in Properties->Number->Fixed to give 2 decimal..

     Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.