topic Text in Gauge Chart in QlikView

Text in Gauge Chart

Anonymous — Tue, 06 Mar 2012 11:49:03 GMT

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) &')' &'%'

Text in Gauge Chart

CELAMBARASAN — Tue, 06 Mar 2012 12:04:53 GMT

Hi,

Check with this

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

Celambarasan

Text in Gauge Chart

jagannalla — Tue, 06 Mar 2012 12:09:07 GMT

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?

Text in Gauge Chart

Anonymous — Tue, 06 Mar 2012 12:17:29 GMT

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

kaushiknsolanki — Tue, 06 Mar 2012 12:41:03 GMT

HI,

Try this

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

Regards,

Kaushik Solanki

Text in Gauge Chart

Anonymous — Tue, 06 Mar 2012 12:48:39 GMT

nope, still showing a null value

Text in Gauge Chart

kaushiknsolanki — Tue, 06 Mar 2012 12:49:55 GMT

HI,

Will you please share the QVW file.

Regards,

Kaushik Solanki

Text in Gauge Chart

CELAMBARASAN — Tue, 06 Mar 2012 12:50:32 GMT

Hi,

What expression you used for the gauge chart?

Celambarasan

Text in Gauge Chart

Anonymous — Tue, 06 Mar 2012 12:54:25 GMT

this is the expression i used

=$(eSuccessful)/Count(AgentCode)

Text in Gauge Chart

CELAMBARASAN — Tue, 06 Mar 2012 12:59:26 GMT

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

Re: Text in Gauge Chart

kaushiknsolanki — Tue, 06 Mar 2012 13:01:11 GMT

Hi,

Why dont u try

=num($(eSuccessful)/Count(AgentCode),'#,##0%')

Regards,

Kaushik Solanki

Text in Gauge Chart

Anonymous — Tue, 06 Mar 2012 13:02:37 GMT

works, thanks a lot!