exclude data in a table without selection

[#1]

hi

i have this data table:

i search to see task with TEXT1 or TEXT2 null without selection in a table and i dont know how do that

Task	Text2	Text1
Task1	eaea
Task1
Task2
Task1	aeaea
Task1		aeaea
Task2	aeae	aeaea
Task3	aeae	aeaea
Task2		aaea
Task2	aeae	aeaze
Task3		aeae
Task3		aea
Task3	aea	aea

[#2]

Hi,

Instead of using a table box you can use a straight table as in attached qvw file.

May be this helps you.

Thanks & Best Regards,

Kuldeep Tak

[matt_crowther]

Attached is a solution (I think).

The solution shows only those Tasks that have NO Text2 and NO Text1 values - it's a straight table as this allows for more manipulation but can display the same results as a TableBox - personally I very rarely use TableBoxes.

Hope that helps,

Matt - Visual Analytics Ltd

[#4]

really thx Kuldeep!!! this forum is really efficient.

[#5]

thx too matt yes i search to see text1 null or text2 nul but with your help i see the way to do that.