Discussion Board for collaboration on QlikView Scripting.
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 ?
Solved! Go to Solution.
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 ?
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.
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.