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.
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.
See the attached qvw.
the expretion like this in expretions tab click on symbal and in text colet write down the expretion as bellow.