Text In Chart - Removing Decimal Places

Tue, 10 Jul 2012 12:00:05 GMT

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

Re: Text In Chart - Removing Decimal Places

MayilVahanan — Tue, 10 Jul 2012 12:35:29 GMT

Hi,

Try this,

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

Hope it helps

topic Text In Chart - Removing Decimal Places in QlikView

Text In Chart - Removing Decimal Places

Re: Text In Chart - Removing Decimal Places