color buttons based on measure

[qlikviewwizard]

Hi All,

I want to show different colored radio buttons based on the salary in a report.

Report columns : EMPNO,A,B,SAL and Color radio button column

If SAL is below 40 then Red,

If SAL is between 40 to 60 then yellow,

If SAL is greater than 60 then green.

How to achive this?

Thanks in advance.

TableA:

Load * inline [

EMPNO,A,B,SAL

EMPNO1,A1,B1,100

EMPNO2,A2,B2,20

EMPNO3,A3,B3,30

EMPNO4,A4,B4,40

EMPNO5,A5,B5,50

EMPNO6,A1,B1,70

EMPNO7,A5,B5,60

EMPNO8,A2,B2,20

EMPNO9,A3,B3,30

EMPNO10,A4,B4,80

];

[danieloberbilli · Accepted solution]

Please find qvw attached.

You could use the same in single text-boxes instead of a straight table

[qlikviewwizard]

Hi danieloberbillig

Thanks a ton.