Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

Re: Create Filter using words of certain Field

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.

Highlighted

Re: Create Filter using words of certain Field

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

Highlighted
Not applicable

Re: Create Filter using words of certain Field

Hi Gopi,

Here's the image:

ScreenHunter_875 Oct. 18 13.31.jpg

Highlighted
Not applicable

Re: Create Filter using words of certain Field

Hi Sunny,

Here's the image:

ScreenHunter_875 Oct. 18 13.31.jpg

Highlighted
Specialist
Specialist

Re: Create Filter using words of certain Field

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

Highlighted
Specialist
Specialist

Re: Create Filter using words of certain Field

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

Highlighted
Not applicable

Re: Create Filter using words of certain Field

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.

Highlighted
Not applicable

Re: Create Filter using words of certain Field

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.

Highlighted
Not applicable

Re: Create Filter using words of certain Field

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.