Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Arjunarao
Honored Contributor II

Colors based on salaries

Hi All,

I want to show the colors based on the Salaries of the Employees.

If EMP SAL>=4500 show green,EMP SAL>=3500 show ,EMP SAL<=2500 show red.

Thanks in advance.

1 Solution

Accepted Solutions
qlikmsg4u
Valued Contributor

Re: Colors based on salaries

use this expression in expression background or text colors

=If(sum(SAL)>=4500,Green(),If(sum(SAL)>=3500,LightGreen(),If(sum(SAL)<=2500,Red(),LightCyan())))

Capture.PNG

10 Replies
qlikmsg4u
Valued Contributor

Re: Colors based on salaries

use this expression in expression background or text colors

=If(sum(SAL)>=4500,Green(),If(sum(SAL)>=3500,LightGreen(),If(sum(SAL)<=2500,Red(),LightCyan())))

Capture.PNG

Re: Colors based on salaries

Cannot open your qvw because I am using PE version of QlikView, but may be this for your background color expression:

If([EMP SAL]<= 2500, Red(),

If([EMP SAL]>= 3500 and [EMP SAL] < 4500, Yellow(),

If([EMP SAL]>= 4500, Green())))

Note: You don't have any color for between 2500 and 3500.

HTH

Best,

Sunny

Not applicable

Re: Colors based on salaries

Hi ,

In the background color of expression write this expression for color:

if(sum(SAL)>=4500 ,green(),

if((sum(SAL)>=3500 and  sum(SAL)<4500),yellow(),

if(sum(SAL)<=2500,red())))

Thanks

Khushboo

pokassov
Valued Contributor

Re: Colors based on salaries

hi!

1. Name the expression Salary.

2. Dimenstion -> ->Text Color

=if([Salary]>4500,green(),

  if([Salary]>3500, yellow(),

  if([Salary]<=2500, red()))

)

Partner
Partner

Re: Colors based on salaries

In the color property of table you can set the color amount lower than,upper than,and average  whatever condition you want...

rgvavihs
Valued Contributor

Re: Colors based on salaries

Hi

=if(sum(SAL)>=4500,Green(),if(sum(SAL)>=3500 and sum(SAL) <4500 ,Yellow(),if(sum(SAL)<=2500,Red())))

krishna20
Valued Contributor II

Re: Colors based on salaries

Hi,

May be this?? also find sample app.Qlik_Help.png

MVP & Luminary
MVP & Luminary

Re: Colors based on salaries

Hi,

Try this background color expression

If([EMP SAL]>=4500, Green(),

     If([EMP SAL]>=3500, Blue(),

      If([EMP SAL]<=2500, Red())))


Hope this helps you.


Regards,

Jagan.

Not applicable

Re: Colors based on salaries

Hi,

   See the attached qvw.

the expretion like this in expretions tab click on symbal and in text colet write down the expretion as bellow.

=IF(sum(SAL)<=2500,Red(),

IF(sum(SAL)>=3500,Green(),

IF(sum(SAL)>=4500,Yellow(),LightBlue())))