Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ingridmerx
Contributor III
Contributor III

Filter on part of text

I want to filter a graphic in QV on just part of a column's text value. So not just the whole content of the record but a part of it. e.g. only select records that contain "example". This would give me all records with value: "This is an example". What is the right syntax? thank you

1 Solution

Accepted Solutions
ingridmerx
Contributor III
Contributor III
Author

I found it!

I used:

=aggr(if(NOT WildMatch(column name,'Examp*'), column name), column name)

which will give me all the records except the ones with Examp in it.

Thank you for all your replies!

View solution in original post

8 Replies
prma7799
Master III
Master III

Like this ?

=PurgeChar('This is an example' , 'This is an')

If you have another expected output so please share some sample data with us.

ingridmerx
Contributor III
Contributor III
Author

No that is not what I ment. I want to filter records in a graphic (or table) on a certain text value of a column.

So, for example all records which contains the letters "examp" wil return all records that contains this word:

"this is an example"

"this is also an example"

But not the record:

"this is wrong written exxampple"

Anonymous
Not applicable

sum({< YOURFIELD= {"*example*"} >}  YOURMEASURE)

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Maybe you can use the object search tool and use * to search what you want.

Cheers.

tresesco
MVP
MVP

I guess you need to use set analysis. Say you have a chart showing sales. You could try expression like:

=Sum({<TextField={'*example*'}>}Sales)

Assuming TextField is the name that contains your text like shown above.

ingridmerx
Contributor III
Contributor III
Author

Maybe I am thinking too difficult, but the only thing I want is to filter a table in a graphic object on the content.

I want to show all the records in a text column that contains a certain group of characters.

e.g. this is the column with text records:

this is a large house

this is a big house

this is a small house

this is a larger house

I want to filter this on "large" and this should resolve in:

this is a large house

this is a larger house

ingridmerx
Contributor III
Contributor III
Author

I found it!

I used:

=aggr(if(NOT WildMatch(column name,'Examp*'), column name), column name)

which will give me all the records except the ones with Examp in it.

Thank you for all your replies!

RyCarm
Contributor II
Contributor II

Hello, I know I'm late but quick question... Where would you type this formula to get the results?