topic Condition on a table in QlikView

Condition on a table

Thu, 07 May 2009 15:44:47 GMT

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.

Condition on a table

Thu, 07 May 2009 16:20:52 GMT

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

Condition on a table

Thu, 07 May 2009 18:05:16 GMT

Thank you Mark.

It's ok now.

Regards Eva