topic Re: Colors based on salaries in QlikView

Colors based on salaries

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

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.

Re: Colors based on salaries

qlikmsg4u — Mon, 31 Aug 2015 09:15:53 GMT

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

Re: Colors based on salaries

sunny_talwar — Mon, 31 Aug 2015 09:18:01 GMT

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

Re: Colors based on salaries

Mon, 31 Aug 2015 09:18:23 GMT

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

Re: Colors based on salaries

pokassov — Mon, 31 Aug 2015 09:18:37 GMT

hi!

1. Name the expression Salary.

2. Dimenstion -> ->Text Color

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

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

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

)

Re: Colors based on salaries

shair_abbas — Mon, 31 Aug 2015 09:30:24 GMT

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

Re: Colors based on salaries

Anonymous — Mon, 31 Aug 2015 09:42:26 GMT

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

Re: Colors based on salaries

krishna20 — Mon, 31 Aug 2015 10:30:55 GMT

Hi,

May be this?? also find sample app.

Re: Colors based on salaries

jagan — Mon, 31 Aug 2015 10:35:12 GMT

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.

Re: Colors based on salaries

Mon, 31 Aug 2015 10:59:03 GMT

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

Re: Colors based on salaries

qlikviewwizard — Mon, 31 Aug 2015 11:29:36 GMT

Thank you all.