Announcements
cancel
Showing results for
Did you mean:
Master 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.

1 Solution

Accepted Solutions
Specialist

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
Specialist

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

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

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

Specialist

hi!

1. Name the expression Salary.

2. Dimenstion -> ->Text Color

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

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

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

)

Partner - Creator

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

Anonymous
Not applicable

Hi

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

Specialist II

Hi,

May be this?? also find sample app.

Luminary Alumni

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

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

Community Browser