In KPI gauge chart one is increase in +ve. Another is also increase in -ve. How to make it both now display in Green zone ?

[paulyeo11]

HI All

my gauge chart ve display 2 set of data :-

Case 1

100 increase to 110 as +10 % increase

Case 2

-100 increase to -110 as +10 % increase

How to make it for case 1 display in green zone .  For case 2 display in red zone ? ( Since case 2 is lost money )

Now both display in Green zone. Which is wrong.

Paul

[HirisH_V7]

Hi,

Check the attachments,

Is that what you desired. !

[MarcoWedel]

Please post example data/app.

Regards

Marco

[MK_QSL]

100 to 110

=(110-100)/100

= 10/100

=10%

-110 to -100

=(-100-(-110))/(-110)

=(-100+110)/(-110)

=10/(-110)

=-9%

Let me know if I am wrong !

[paulyeo11]

Hi manish

Yes you are correct.

It is possible to add condition in expression ,in case both value are -ve then compute result will be set -ve.

Paul

Sent from my iPhone

[MK_QSL]

like this?

[maxgro]

100 increase to 110 as +10 % increase

fabs(110-100) / 100                      --> 10%

(110-100) / fabs(100)                      --> 10%

-100 increase to -110 as +10 % increase

I'm not sure in this case you have a +10%. May be a -10%?

I think the sign should be the abs of numerator   denominator

fabs((-110)-(-100)) / (-100)          --> -10%

((-110)-(-100)) / fabs(-100)          --> -10%

[paulyeo11]

Hi All

Thank you for your sharing,

Enclosed my QV Doc.

Paul !

[paulyeo11]

Hi All

Many thank , it is possible to apply your answer into my QV doc ?

As i have try both solution with file attachment , i cannot figure out how to apply.

Paul