Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

My KPI chart expression and setting not display correctly

Hi All

My KPI chart have 2 issue :-

1. The color bar green is not display. now it display as white color.

2. My LY 2014 CCC is not display as 139. now display as blank.

How some one can help me ?

Paul

1 Solution

Accepted Solutions
mphekin12
Specialist
Specialist

Something like this?

View solution in original post

8 Replies
mphekin12
Specialist
Specialist

Hope this helps.

paulyeo11
Master
Master
Author

Hi Sir

Thank you very much .

I make some mistake on my question . and the KPI chart color go wrong.

Actual i wanted :-

How to make 0 to 95 all green color ?

How to make 0 to -95 all red color ? ( now white color )

May i know how to achieve the above ?

Paul

mphekin12
Specialist
Specialist

Something like this?

Not applicable

Hi,

For 1st Question: We need to change the setting. Go to Chart Properties->Presentation ,select Lower bound as 0 for Segment2 and Lower bound as -95 for Segment1.

For 2nd Question:  We need add text in Gauge chart.  Go to Chart Properties->Presentation- Click on add button from Text in Chart and  Inside Text write your above expression.

Now Press CTRL + SHIFT you will get Red Rectangles and drag and Drop to move the text box.

Please find attachment for you referance.

Thanks,

Uday

paulyeo11
Master
Master
Author

Hi Sir

Thank you it work fine now.

My KPI is cash conversion cycle.

If the value -55 meaning is better. so i just change the color to green.

If the value +55 meaning is bad . so i just change the color to Red.

After i change green to red and red to green , Now it work.

Paul

mphekin12
Specialist
Specialist

Great!  Glad I was able to help.

paulyeo11
Master
Master
Author

Hi Sir

Thank you.for.your detail expaination. 

Sent from Samsung Mobile

Not applicable

You are welcome Paul