This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
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
Where MyExp is the label of your Sum(Sal) expression, if there are spaces in them put it between  brackets.
View solution in original post
Try like this
= if(PreviousSales - CurrentSales > 0, Green(), Red())
Hi I tried to write
below expression under Background color
=if(Above(Sum(Sal) - Sum(Sal) > 0 , Red(),Green())
but its not working.
use this expression:
if(Sal > Below(Sal) , Red(), Green()))
in background exp, where Sales is the name of the expression.