Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

'Text in chart' error on a gauge

Hi all

I can't seem to figure out why this isn't working.  I've created a gauge.  The needle point to the correct figure and if you hover over the text I've added to show the numerical %, then it hovers the correct figure - but the actual text displayed keeps coming up as 100% (which is wrong).

='% satisfied: '&Num(Count(Q2_S_OverSatComp) / Count(TOTAL [Q2_V_OverSatComp]),'##.#%')

Can anyone see an error in this expression?  Or is it a setting somewhere that needs updating?

Thanks in advance.

Alex

1 Reply
ngulliver
Partner - Specialist III
Partner - Specialist III

Hi, Alex.

I would recommend breaking the equation into chunks if you haven't done so already. Create a text object for each side of the equation to check the values in each.

One thing that strikes me from your sampe is that you are counting Q2_S_OverSatComp against Q2_V_OverSatComp

Is that correct ?

Hopefully that helps. Otherwise you may need to put a bit more information about the fields for anyone else to properly diagnose the issue.

Neil.