# New to QlikView

Discussion board where members can get started with QlikView.

New Contributor II

## Text in Gauge Chart

I'm trying to add text to my Gauge chart so that you can see the percentage.

I have the following expression, but something isn't right.

Any Ideas?

=Num((\$(esuccessful)/count(AgentCode))*100,0) &')' &'%'

1 Solution

Accepted Solutions
MVP

## Text in Gauge Chart

Hi,

Check with this

=Num((\$(esuccessful)/count(AgentCode))*100,0)&'%'

Celambarasan

11 Replies
MVP

## Text in Gauge Chart

Hi,

Check with this

=Num((\$(esuccessful)/count(AgentCode))*100,0)&'%'

Celambarasan

Valued Contributor III

## Text in Gauge Chart

Hello,

Try this...

= '(' & Num((\$(esuccessful)/count(AgentCode))*100,0) &')' &'%'

IF NOT:

What is the value in variable and what is the Count(AgentCode). What is the output you want?

New Contributor II

## Text in Gauge Chart

neither of those are working either.

They all show up as Null values

Count(AgentCode)  -   counts the number of calls made

esuccessful             -    counts the number of successful calls

If you hover the mouse over the gauge chart, it shows the percentage of successful calls over total calls.

But i want to be able to see that percentage without hovering the mouse over the chart

## Text in Gauge Chart

HI,

Try this

Num((\$(esuccessful)/count(AgentCode),'#,##0%')

Regards,

Kaushik Solanki

New Contributor II

## Text in Gauge Chart

nope,  still showing a null value

## Text in Gauge Chart

HI,

Will you please share the QVW file.

Regards,

Kaushik Solanki

MVP

## Text in Gauge Chart

Hi,

What expression you used for the gauge chart?

Celambarasan

New Contributor II

## Text in Gauge Chart

this is the expression i used

=\$(eSuccessful)/Count(AgentCode)

MVP

## Text in Gauge Chart

Hi,

Try with this.

=Num(\$(=eSuccessful)/Count(AgentCode),'###%')

if not working

Can you tell me what expression you have used in the variable eSuccessful?

Celambarasan

Community Browser