Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

Re: Back ground colour based on couple of condition

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
Highlighted
Specialist
Specialist

Re: Back ground colour based on couple of condition

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

Highlighted
Creator
Creator

Re: Back ground colour based on couple of condition

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

Highlighted
Specialist
Specialist

Re: Back ground colour based on couple of condition

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

Highlighted
Creator
Creator

Re: Back ground colour based on couple of condition

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

Highlighted
Specialist
Specialist

Re: Back ground colour based on couple of condition

Thanks Sangeetha, This is what I looked forward to.

Neville

Highlighted
Creator III
Creator III

Re: Back ground colour based on couple of condition

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)))