Qlik Community

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 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
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.

Thanks in advance.

Neville

1 Solution

Accepted Solutions
sangeess21
Creator
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())

View solution in original post

6 Replies
nevilledhamsiri
Specialist
Specialist
Author

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

sangeess21
Creator
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.

nevilledhamsiri
Specialist
Specialist
Author

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

sangeess21
Creator
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())

View solution in original post

nevilledhamsiri
Specialist
Specialist
Author

Thanks Sangeetha, This is what I looked forward to.

Neville

MarioCenteno
Creator III
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)))