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.
Say for example if hav bar chart with month as dimension
and sales as measures ..
I want to compare sales each month with previous month and
change color (for example green,red)...
Thanks in advance,
=If(Above(Sum(Measure))>Sum(Measure), Green(), Red()) // background color expression
Similarly you can use Below() as well.
See attached sample too.
View solution in original post
Thanks tresesco ,
Actually i dont understand how it works ..
can you explain a bit ..??
And another doubt .. it s not properly working on line chart...
i.e) if line moves down it should appear red .
Above() - as the name says - it gets the value(expression here) of the earlier row. Then, rest part is simple comparison might not require explanation. For details, please refer help or reference manual.
And while applying it s not properly working on line chart...
i.e) if line moves down it should appear red .but not
Try to share your qvw with sample data. See: Preparing examples for Upload - Reduction and D... | Qlik Community
I tried and it works