Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selecting on what's NOT in a text field (multiple strings)

My data has a text field that contains status info like "shipped" "on backorder" "in progress" etc - there's a whole series of them.

How can I create an action button (or some other method) that selects all rows that are not "shipped" and also not "on backorder"?  I can't just click on "in progress" because then I lose all the others.  I don't need it to be dynamic - it'll always be the same terms I'm excluding from my list.

I'd appreciate details - this is my first week working with Qlikview so I'm still finding my way around!

2 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Can you upload the sample file, so that it would be helpful to solve.

Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Check the attachment, hope this helps you.

Regards,

Jagan.