Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT 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
marcioarruda
Creator III
Creator III

jj

I made inline as an example.

You can bring the devices from a table and only the filter conditions you put on inline ... or it may be on the table as well.

Not applicable
Author

Marcio,

Sorry but I don't know how to bring the devices from a table instead of listing them.

I only need a way call al that models without listing them.

Not applicable
Author

Hi Anil,

I exactly mean that.

The problem is that I don't know how to bring the devices from a table instead of listing them.

I only need a way call al that models without listing them because are more than 2000.

marcioarruda
Creator III
Creator III

I'm sorry, but I thought you had the devices to a table.

You can create an Excel spreadsheet with all of them, and load directly from the spreadsheet.

Then you will only increasing with new records.

Anil_Babu_Samineni

If you have huge data, then subfield take the correct way. So, if you want only last word then subfield is sufficient for you. Does the data has any tricky row or value. If yes, try to share application which only take that dimension and share with us so so people can understand easily to you. So that we can help you easily get to say that application with us that's really glad to help thank you

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

Sorry If you misunderstood me, I have everything in an excel.

I managed to create filters with subfields when the data is consistent. For example with the Brands, because always the first word was the brand:

ScreenHunter_878 Oct. 19 14.10.jpg

In the other cases, how can I create fields from certain words?

For example, for the conditions, not always the last words is the condition:

ScreenHunter_879 Oct. 19 14.27.jpg

1rs line: Bom (word n°5)

2nd line: Excelente (word n°2)

3rd line: Muito Bom (word n°3 & n°4)


In this cases, I need to create some Field using the words: "Bom", "Excelente", "Muito Bom" in order to be able to filter.

Do you know how to do this?

Not applicable
Author

Sorry If you misunderstood me, I have everything in an excel.

I managed to create filters with subfields when the data is consistent. For example with the Brands, because always the first word was the brand:

ScreenHunter_878 Oct. 19 14.10.jpg

In the other cases, how can I create fields from certain words?

For example, for the conditions, not always the last words is the condition:

ScreenHunter_879 Oct. 19 14.27.jpg

1rs line: Bom (word n°5)

2nd line: Excelente (word n°2)

3rd line: Muito Bom (word n°3 & n°4)


In this cases, I need to create some Field using the words: "Bom", "Excelente", "Muito Bom" in order to be able to filter.

Do you know how to do this?

Not applicable
Author

I managed to create filters with subfields when the data is consistent. For example with the Brands, because always the first word was the brand:

ScreenHunter_878 Oct. 19 14.10.jpg

In the other cases, how can I create fields from certain words?

For example, for the conditions, not always the last words is the condition:

ScreenHunter_879 Oct. 19 14.27.jpg

1rs line: Bom (word n°5)

2nd line: Excelente (word n°2)

3rd line: Muito Bom (word n°3 & n°4)


In this cases, I need to create some Field using the words: "Bom", "Excelente", "Muito Bom" in order to be able to filter.

Do you know how to do this?

Not applicable
Author

I managed to create filters with subfields when the data is consistent. For example with the Brands, because always the first word was the brand:

ScreenHunter_878 Oct. 19 14.10.jpg

In the other cases, how can I create fields from certain words?

For example, for the conditions, not always the last words is the condition:

ScreenHunter_879 Oct. 19 14.27.jpg

1rs line: Bom (word n°5)

2nd line: Excelente (word n°2)

3rd line: Muito Bom (word n°3 & n°4)


In this cases, I need to create some Field using the words: "Bom", "Excelente", "Muito Bom" in order to be able to filter.

Do you know how to do this?

marcioarruda
Creator III
Creator III

But qvw file I sent, does just that:

bom.JPG