Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Contributor III

Re: Create Filter using words of certain Field

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.

Highlighted
Not applicable

Re: Create Filter using words of certain Field

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.

Highlighted
Not applicable

Re: Create Filter using words of certain Field

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.

Highlighted
Contributor III

Re: Create Filter using words of certain Field

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.

Highlighted

Re: Create Filter using words of certain Field

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)
Highlighted
Not applicable

Re: Create Filter using words of certain Field

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?

Highlighted
Not applicable

Re: Create Filter using words of certain Field

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?

Highlighted
Not applicable

Re: Create Filter using words of certain Field

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?

Highlighted
Not applicable

Re: Create Filter using words of certain Field

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?

Highlighted
Contributor III

Re: Create Filter using words of certain Field

But qvw file I sent, does just that:

bom.JPG