topic 'Text in chart' error on a gauge in QlikView

'Text in chart' error on a gauge

Mon, 05 Aug 2013 12:20:39 GMT

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

Re: 'Text in chart' error on a gauge

ngulliver — Tue, 06 Aug 2013 08:59:47 GMT

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.