How to use between case in Conditional formatting

[bhuprakash]

Hi All,

I want to mark background color with yellow color if percentage falls between 40% to 60%.

Please help me that how can i do the same. Below is the screenshot.

[Anil_Babu_Samineni]

Use 0.6 ??

[martinpohl]

on the visualtion tab you can only use one limit.

go to tab expressions, collaps the + in front of the third expression, select background color

there you can use:

if [Percentage%] >= 0.4 and [Percentage%] <= 0.6,yellow())

although there is a Statement that Percentage% is a unknown field this works, but be sure that expression label is case sensitive and remember spaces

regards

[bhuprakash]

OK.. Let me try

[bhuprakash]

Hi Martin, This is working but only for particular cell. Is it possible to  color complete row if the condition is true.

[martinpohl]

so you have to copy the background expression to every expression and dimension

[bhuprakash]

And also please tell me that how can i sort  Percentage(%) in Descending order. Because there is option Y- Value but it is sorting Total_Employee.

[bhuprakash]

any suggestion on the same ?

[Anil_Babu_Samineni]

You said, You will get back. I thought you already got output. Anyway, Will you provide mock application to investigate?

[bhuprakash]

Dear Anil,

Color formatting issue is resolved. I want to sort the data using Percentage(%) column.

Also I want to subtract Percentage from First table - Percentage from Second table

Please let me know how to attached .qvw file so that i can send u.