topic color in line chart in QlikView

color in line chart

soha1902 — Mon, 29 Jun 2015 11:06:50 GMT

Hi All,

I am using one line chart in my dashboard. In this chart Emp is a dimension and Sum(Sal) is expression.

Now my requirement is, if my line is increasing then it will show as green line and if it will decreasing then Red color.

please help.

MayilVahanan — Mon, 29 Jun 2015 11:10:07 GMT

Try like this

Background Color:

= if(PreviousSales - CurrentSales > 0, Green(), Red())

soha1902 — Mon, 29 Jun 2015 11:15:39 GMT

Hi I tried to write

below expression under Background color

=if(Above(Sum(Sal) - Sum(Sal) > 0 , Red(),Green())

but its not working.

stigchel — Mon, 29 Jun 2015 11:17:27 GMT

You can use the background color option of your expression (click on the plus sign in front of the expression) and use something like this

if(MyExp<Below(MyExp),lightgreen(),lightred())

Where MyExp is the label of your Sum(Sal) expression, if there are spaces in them put it between [] brackets.

jsingh71 — Mon, 29 Jun 2015 11:24:42 GMT

use this expression:

if(Sal > Below(Sal) , Red(), Green()))

Anonymous — Mon, 29 Jun 2015 11:26:33 GMT

Hi,

Use

(Sales-Below(Sales)<=0,green(),red())

in background exp, where Sales is the name of the expression.