Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
PFA
Use 0.6 ??
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
OK.. Let me try
Hi Martin, This is working but only for particular cell. Is it possible to color complete row if the condition is true.
so you have to copy the background expression to every expression and dimension
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.
any suggestion on the same ?
You said, You will get back. I thought you already got output. Anyway, Will you provide mock application to investigate?
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.