Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

chrisgoudy
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

Text in Gauge Chart

Hi,

     Check with this

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

Celambarasan

11 Replies

Text in Gauge Chart

Hi,

     Check with this

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

Celambarasan

jagannalla
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?

chrisgoudy
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

chrisgoudy
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

Text in Gauge Chart

Hi,

     What expression you used for the gauge chart?

Celambarasan

chrisgoudy
New Contributor II

Text in Gauge Chart

this is the expression i used

=$(eSuccessful)/Count(AgentCode)

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