Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Check with this

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

Celambarasan

View solution in original post

11 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Check with this

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

Celambarasan

jagannalla
Partner - Specialist III
Partner - Specialist III

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?

Anonymous
Not applicable
Author

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

   Try this

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable
Author

nope,  still showing a null value

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

     Will you please share the QVW file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     What expression you used for the gauge chart?

Celambarasan

Anonymous
Not applicable
Author

this is the expression i used

=$(eSuccessful)/Count(AgentCode)

CELAMBARASAN
Partner - Champion
Partner - Champion

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