topic Re: Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart in QlikView

Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

taha_mansoor — Fri, 20 Nov 2020 18:02:30 GMT

Hi,

I am simply showing up the production ratio with sale using a gauge chart. The expression is Sum(Production)/Sum(Sale). I am using the same expression in 'Text in Chart' as well to show the numeric figure beside the chart needle. The problem is that the expression result is different in gauge chart and in Text. In gauge, it shows 23% but in text it shows 19.36%. I can't understand why is this happening. The expression is same on both places but result is different.

Screen shot of my gauge chart is attached.

Regards,

Taha

Re: Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

Marcio_Campestrini — Fri, 20 Nov 2015 13:38:45 GMT

Hi Muhammad

Can you share a sample app? Or can you post your expressions?

Márcio

Re: Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

Fri, 20 Nov 2015 13:52:42 GMT

can you share your sample excel file

Re: Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

taha_mansoor — Fri, 20 Nov 2015 14:27:16 GMT

To ALL,

I can't share the real app I am working on, I am afraid. The expressions I am using are:

Gauge Expression: =Sum(BeveragesProduction)/Sum(BeveragesSale)

Text in Chart Expression: =Num(Sum(BeveragesProduction)/Sum(BeveragesSale), '##.##%')

I just tried to produce the case by making some dummy data on excel and then forming the gauge chart as same as I am doing in real app but case is not producing. Very strange. Does anyone has any idea what is wrong ?

Re: Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

Marcio_Campestrini — Fri, 20 Nov 2015 15:04:22 GMT

Hi Muhammad

Only looking to your expressions it looks like there is no error.

Unfortunately I can't say more without looking at the chart.

Márcio

Re: Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

roger_stone — Fri, 20 Nov 2015 15:21:17 GMT

On the Presentation tab for the Chart, what values have you got for Min and Max Gauge Settings?

Re: Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

Fri, 20 Nov 2015 15:24:36 GMT

may be the num format has a strange behaviour

I tried yours and mine

see attached qvw

try this one istread

=num(sum(Production)/Sum(Sales) , '# ##0,00%')

best regards

chris

Re: Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

taha_mansoor — Mon, 23 Nov 2015 07:52:18 GMT

roger.stone‌ : Min 0 and Max 1

@christianj : I tried yours and its appearing like this:

Any other idea ?

Re: Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

Wed, 25 Nov 2015 15:35:35 GMT

it seems to be linked to your parameters format

did you just open my qvw or did you copy/paste what was inside into yours ?

chris

Re: Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

Wed, 25 Nov 2015 15:48:46 GMT

You should not need 2 expressions. If you select the option on General tab'show title in chart' and leave the text biox blank, it will use the expression and place in the object. or copy/pase expression and palce in the textbox and format it. The value in the title can then be moved using vtrl-shift

try it without formatting - the result should be correct

you would get something along the lines of the below example showing the values are the same, jsut not formatted (applciation provided by christianj above)

Re: Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

taha_mansoor — Thu, 26 Nov 2015 08:40:21 GMT

christianj‌ Yes I did match all the configuration for your gauge chart in your qvw with my gauge chart in my qvw but result is same in my qvw. Basically, I got the clue where actually the problem is. The text in chart returning the correct figure. The needle is showing the incorrect figure in gauge, however, the expression used on both the places are exactly same. Now it needs to be find out why needle is pointing the incorrect figure.

Taha

Re: Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

taha_mansoor — Thu, 26 Nov 2015 08:46:04 GMT

@Adam Krepistman: Yes I tried the way you told and its returning the mismatched figure and that figure is as same as the text in chart expression one. Well, I have got the clue here. The text in chart returning the correct figure. The needle is showing the incorrect figure in gauge, however, the expression used on both the places are exactly same. Now it needs to be find out why needle is pointing the incorrect figure.

Taha

Re: Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

Marcio_Campestrini — Mon, 31 Oct 2016 18:55:56 GMT

Have you solved your problem? If you did, please choose the correct answer and help us to keep community focused.