Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Malhar
Contributor II
Contributor II

Filter

Hii,

I want to filter my data in a column.

For eg. I need to show only “not found” data, but when I do that, it searches for “not” differently and “found” differently. Hence, as a result I get the data which has “not” in it, and “found” in it.

Can anyone help?

1 Solution

Accepted Solutions
Or
Champion
Champion

Exactly as has been posted in this thread - you search for “Reklamation nicht gerechtfertigt” (or perhaps “*Reklamation nicht gerechtfertigt*” if this might not be the start/end of a word).

View solution in original post

9 Replies
mruehl
Creator III
Creator III

Maybe you can try *not*found*

tresesco
MVP
MVP

Try putting single quotes around your search string, like: 'not found' or with double quotes for cases insensitive search, like "Not fOUND".

Malhar
Contributor II
Contributor II
Author

Hii,

thanks for your response. i tried but it did not work.

will the trim(not found) work?

 

thanks 🙂

Malhar
Contributor II
Contributor II
Author

Hii,

thanks for your response, but it did not work.

will trim('not found')work?

thanks.

tresesco
MVP
MVP

Hi @Malhar ,

Try to explain a bit more about your context, where and how exactly you are trying to do. Then it become easier for us to guide you.

Or
Champion
Champion

Searching for "Not Found" will search for the explicit string "Not Found" and will not return hits on "Not" or "Found" individually.

Malhar
Contributor II
Contributor II
Author

image.jpg

As you can seen in the picture, the colum named ‘Meldungslangtext’ include information “Reklamation nicht gerechtfertigt”. And I only want to see the data which contains this information.

How can I do that? 

Or
Champion
Champion

Exactly as has been posted in this thread - you search for “Reklamation nicht gerechtfertigt” (or perhaps “*Reklamation nicht gerechtfertigt*” if this might not be the start/end of a word).

Malhar
Contributor II
Contributor II
Author

Hii,

thanks a lot, it worked.

😀