Condition on a table

[#1]

Hi,

Currently, I develop my second QV application. I would display 2 tables on me sheet. One with status =Y and another with status = N.

In fact, my problem is : who I can define a condition for solely a table?

I have tested all solution who I can thought.

Have you some ideas for define that?

Thank you in advance.

Eva.

[#2]

Hello Eva,

I don't know if this is possible with normal tables but I know you can use chart based straight tables for this. If you want to display two tables based on the same data but with different filters you should use the condition/filter in an expression and supress zero or empty values. The expression is like:

=IF(Status='Y',0,Value)

But possibly there are better/easier solutions for this.

regards Mark

[#3]

Thank you Mark.

It's ok now.

Regards Eva