# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for
Did you mean:
Specialist

## Back ground colour based on couple of condition

As per the attached table, the variance created in the front end to be given with back ground colour as follows

If the variance is less than 0, & until the variance go over -5000, it should be given with green colour. Also if the variance is more than  0 & until it goes up to +5000, it should be given with green colour & anything over or below (+5000,-5000) with green.

If I am sent with the expression this is mostly welcome.

Neville

1 Solution

Accepted Solutions
Creator

Add this expression under Expression/Background color.

if(SUM({<BRANCH={'RA','EH','K7','K9','EM','AS','TA'}>}VARINACE)>5000 or SUM({<BRANCH={'RA','EH','K7','K9','EM','AS','TA'}>}VARINACE)< -5000,LightRed(),LightGreen())

6 Replies
Specialist
Author

Sorry the colour which does not within that range should be in Red. Sorry for printing error

Creator

Did you mean if variance is between (-5000,5000) green and anything outside this range as red? If yes, please refer the attached file.

Specialist
Author

Could you please send me the expression. Cannot open your file as long as I have personnel edition

Creator

Add this expression under Expression/Background color.

if(SUM({<BRANCH={'RA','EH','K7','K9','EM','AS','TA'}>}VARINACE)>5000 or SUM({<BRANCH={'RA','EH','K7','K9','EM','AS','TA'}>}VARINACE)< -5000,LightRed(),LightGreen())

Specialist
Author

Thanks Sangeetha, This is what I looked forward to.

Neville

Creator III

Try

expression background color

If( Column(3)>5000 and Column(3) <-5000, RGB(0, 255, 0),

If( Column(3)>=0 and Column(3) <5000 , RGB(0, 244, 0),RGB(255,0,0)))

Community Browser