Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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 ?

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

8 Replies
HirisH_V7
Master
Master

Hi,

Check the attachments,

Is that what you desired. !

HirisH
“Aspire to Inspire before we Expire!”
MarcoWedel

Please post example data/app.

Regards

Marco

MK_QSL
MVP
MVP

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
Master
Master
Author

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
MVP
MVP

like this?

maxgro
MVP
MVP

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
Master
Master
Author

Hi All

Thank you for your sharing,

Enclosed my QV Doc.

Paul !

paulyeo11
Master
Master
Author

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