Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

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
Not applicable

Re: My KPI chart expression and setting not display correctly

Something like this?

8 Replies
mphekin12
Not applicable

Re: My KPI chart expression and setting not display correctly

Hope this helps.

paulyeo11
Not applicable

Re: My KPI chart expression and setting not display correctly

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
Not applicable

Re: My KPI chart expression and setting not display correctly

Something like this?

Not applicable

Re: My KPI chart expression and setting not display correctly

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
Not applicable

Re: My KPI chart expression and setting not display correctly

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
Not applicable

Re: My KPI chart expression and setting not display correctly

Great!  Glad I was able to help.

paulyeo11
Not applicable

Re: My KPI chart expression and setting not display correctly

Hi Sir

Thank you.for.your detail expaination. 

Sent from Samsung Mobile

Not applicable

Re: My KPI chart expression and setting not display correctly

You are welcome Paul