How to display only those rows in straight table based on certain criteria.

[#1]

Hi All,

The above is a straight table. I have two requirements

1) If 'Is he available' column is greater than 50%, I should display the 'Employee Name' in one color. If it is less I should display it in another color. How to do it. Main idea is to differentiate the rows with >50% and <=50%.

2) I am providing an input box to the user to input the % value for available. I should only display those dimensions for which available is greater than or equal to the value of the input box. How to do it?

Could you please help me with these above requirements.

Thanks in advance.

[tresesco]

Try to share your sample qvw here.

[dharmarasu]

hi,

in the dimension Employee_Name -> clik the + sign and you can see background color->

u want to write

=if([your Expression]>50,green(),Red())

see the sample app in attachments...

hope this helps.

-dharma.