Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to change the color of the line chart in QlikView if certain conditions are met. But i don't want the entire line color to change.
there are 2 lines.
Line 1 : Actual Cost
Line 2 : Forecast Gross Cost
i want only the color of the affected portion to change color. For example on line 1, if the Forecast > Actual for the month of November, i want just that portion of the line to turn red(), else, it should be blue().
Anyone have any thoughts on how to achieve this?
i have tried using the 'special segments' portion on the 'colors' tab, but it doesn't work.
i have also tried using a formula in the colors, but it changes the ENTIRE line color, which is not what i want.
let me know if there is a workaround for this
i have attached te QV file as well
thanks!
In the "Background Color" of the expression, you can try:
=If([Gross Costs Forecast] > [Gross Costs Actual],Red(),Blue())
The color only changes at the periods.
NOTE!
i have updated the data for the QV file here.
Sorry about that!
In the "Background Color" of the expression, you can try:
=If([Gross Costs Forecast] > [Gross Costs Actual],Red(),Blue())
The color only changes at the periods.
Something like this?
Check out this attached demo and replace with you values.
thanks for your time and response Krishna!