Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

exclude data in a table without selection

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

TaskText2Text1
Task1eaea
Task1
Task2
Task1aeaea
Task1aeaea
Task2aeaeaeaea
Task3aeaeaeaea
Task2aaea
Task2aeaeaeaze
Task3aeae
Task3aea
Task3aeaaea

4 Replies
Not applicable
Author

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
Specialist
Specialist

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

Not applicable
Author

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

Not applicable
Author

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