topic exclude data in a table without selection in QlikView

exclude data in a table without selection

Fri, 11 Feb 2011 10:11:44 GMT

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

exclude data in a table without selection

Fri, 11 Feb 2011 10:24:47 GMT

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

exclude data in a table without selection

matt_crowther — Fri, 11 Feb 2011 10:27:19 GMT

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

exclude data in a table without selection

Fri, 11 Feb 2011 10:32:03 GMT

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

exclude data in a table without selection

Fri, 11 Feb 2011 10:41:10 GMT

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