Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create Filter using words of certain Field

Hi everyone,


I need to find a way to create a Filter that contains certain words of a determinate Field.

For example: I have this list box of the field "Model"

Imagen integrada 1

I want to create some filters that filter the data depending on the words:

  • One that contains "Bom" or Excelente"
  • One that contains the brands as "Blackberry", "Samsung",etc.
  • One that contains the models "iPhone 5, "Z30", etc.

I would be very grateful if someone help me.

Thanks in advance.

Martín

34 Replies
gopikrishnach
Creator
Creator

Martin,

Can you please provide the clear screenshot of this example as the provided One is not attached properly.

Or

You can use search option in the properties by using *bom* like that.

Gopi.

sunny_talwar

The image seems to be broken for me, would you be able to repost the image to see what you are looking to get?

Not applicable
Author

Hi Gopi,

Here's the image:

ScreenHunter_875 Oct. 18 13.31.jpg

Not applicable
Author

Hi Sunny,

Here's the image:

ScreenHunter_875 Oct. 18 13.31.jpg

rupamjyotidas
Specialist
Specialist

I am guessing this:

if(Match(yourfieldname,"Bom", Excelente")>0 ,yourfieldname) as yourfieldname

Same for others

if(Match(yourfieldname,"Blackberry", "Samsung")>0 ,yourfieldname) as yourfieldname

rupamjyotidas
Specialist
Specialist

Is the words consistent? First part seems to be the Brand Name but again iPad2 is not a brand name. You can use strings functions to break the field like subfield() but you need to be careful of the consistency of the data

Not applicable
Author

I want to finally have something like this that work as list box to filter the results:

ScreenHunter_877 Oct. 18 16.13.jpg

The Condition is not a Field. Bom and Excelent are just words inside the Field "Model".

I want to find a way to create that kind of list box which filter that words in the results without modifications in the original file.

Not applicable
Author

I want to finally have something like this that work as list box to filter the results:

ScreenHunter_877 Oct. 18 16.13.jpg

The Condition is not a Field. Bom and Excelent are just words inside the Field "Model".

I want to find a way to create that kind of list box which filter that words in the results without modifications in the original file.

Not applicable
Author

I want to finally have something like this that work as list box to filter the results:

ScreenHunter_877 Oct. 18 16.13.jpg

The Condition is not a Field. Bom and Excelent are just words inside the Field "Model".

I want to find a way to create that kind of list box which filter that words in the results without modifications in the original file.