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

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

Tue, 17 Jun 2014 06:06:16 GMT

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.

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

tresB — Tue, 17 Jun 2014 06:10:51 GMT

Try to share your sample qvw here.

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

dharmarasu — Tue, 17 Jun 2014 06:53:06 GMT

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.