topic Re: 2 decimal points on 'text in chart' in QlikView

2 decimal points on 'text in chart'

Tue, 12 Aug 2014 15:38:53 GMT

We have the following expression on the text of our chart:

=Avg([Q5 The attitude of the operative])=

The chart is a gauge ranging from 0-10. The expressions gives a score which is along the lines of 9.256328; however, we want it fixed to 2 decimal places, i.e. 9.25

Can anyone suggest/highlight how we might do this? Assume it done by editing expression of 'text in chart' but struggling...

Any help would be appreciated.

Chris

Re: 2 decimal points on 'text in chart'

Tue, 12 Aug 2014 15:40:55 GMT

Hi Chris,

You can use the function Num(), the example would be like this:

Num( Avg([Q5 The attitude of the operative]), '###,###.##' )

Try it, should work.

Re: 2 decimal points on 'text in chart'

Anonymous — Tue, 12 Aug 2014 15:41:01 GMT

Properties->Number->Fixed Decimals 2

Re: 2 decimal points on 'text in chart'

Tue, 12 Aug 2014 15:41:15 GMT

you can use the num() function to fix that

Re: 2 decimal points on 'text in chart'

marthacano01 — Tue, 12 Aug 2014 15:44:43 GMT

Did you try?

=num(Avg([Q5 The attitude of the operative]),'###.##')