Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table, background color from two lines condition?

Hi,

I'm working since 3 hours about this problem.

I've this table (picture below) and i want to set cells background to red if  "Livraisons" from "2014" are < "Livraisons" 2013.

I've tried Set analysis and many things but i can't find the answer.

First.jpg

I suppose that i must write expression here :

second.jpg

I thought to search value in table from year 2013 but i don't know how to do this in expression...

Could you help me?

5 Replies
Anonymous
Not applicable
Author

Try something like

     if ( above(Livraisons) < Livraisons , red() )

See attached qvw.

rajkumarb
Creator II
Creator II

HI Beaulieu Mathieu

Try this way

if(Sum({<year={2001}>}sale)<= 200, RGB(0255,0,0),RGB(0,255,0))

if(Sum({<year={2002}>}sale)<= 200, RGB(0255,0,0),RGB(0,255,0))

Not applicable
Author

Thanx for your help.

Your test is OK, but in my case, i have to replace 200 by the other year (year - 1) and i don't want to do the Sum of sales... I just want show values from field "Livraisons"

if(Sum({<year={2001}>}sale)<= 200, RGB(0255,0,0),RGB(0,255,0))


An idea?


canariam
Contributor III
Contributor III

hi,

you can use the attached one.

!

Not applicable
Author

Ok, It's working with "Below" function.

Thank you.