# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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
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()))) 10 Replies
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())))  MVP

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

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

## 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...

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

Valued Contributor II

## Re: Colors based on salaries

Hi,

May be this?? also find sample app.  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())))