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: 
Specialist II
Specialist II

Re: Create Filter using words of certain Field

Or this :

=if(Fieldsname like '*iPhone 5*' or Fieldsname like "*Z30*" ,Fieldsname,null())

Highlighted
Not applicable

Re: Create Filter using words of certain Field

Yes, are consistent. For example, all the models have attributed a condition, "Bom" or "Excelent".

There is any way to do the last picture? That list box filter with the condition.

Highlighted
Creator III
Creator III

Re: Create Filter using words of certain Field

Highlighted
Not applicable

Re: Create Filter using words of certain Field

Thanks Marcio, but no.

What I need to create is this (I made it with paint):

ScreenHunter_877 Oct. 18 16.13.jpg

Highlighted
Creator III
Creator III

Re: Create Filter using words of certain Field

These conditions are fixed?

If so, you can create a InLine with the conditions, and make the search as the item sent.

[Conditions]:

LOAD * INLINE [

  Condition

  'Bom'

  'Excelent'

  ];

Highlighted
Not applicable

Re: Create Filter using words of certain Field

Marcio,

Thanks to that I managed to create the Field "Conditions" and the Listbox but when I clicked in some condition is not working as a filter of the results, I clicked and nothing happens.

Highlighted
Creator III
Creator III

Re: Create Filter using words of certain Field

Try this j j:

Highlighted
Not applicable

Re: Create Filter using words of certain Field

Marcio,

Works great, thanks!

The only problem is:

In LOAD * Inline [

  Name 

Have I to list all the devices? Because I have more than 1500...

Highlighted

Re: Create Filter using words of certain Field

Do You mean this??

Capture.PNG

Script

LOAD Field, SubField(Field, ' ', -1) as Field1;

LOAD * Inline [

Field

Blackberry 9900 Seminovo Bom

Blackberry 9900 Seminovo Excelente

Blackberry 9900 Seminovo Muito Bom

Blackberry Q10 Preto Seminovo Bom

Blackberry Q10 Preto Seminovo Excelente

Blackberry Q10 Preto Seminovo Muito Bom

ipad 2 Wi-Fi + 3G 16GB Branco Seminovo Bom

ipad 2 Wi-Fi + 3G 16GB Branco Seminovo Excelente

ipad 2 Wi-Fi + 3G 16GB Branco Seminovo Muito Bom

ipad 2 Wi-Fi + 4G 32GB Branco Seminovo Bom

ipad 2 Wi-Fi + 4G 32GB Branco Seminovo Excelente

ipad 2 Wi-Fi + 4G 32GB Branco Seminovo Muito Bom

];

For Ref, PFA. Now tell me what is the Issue? Make sure if anyone reply is useful please mark as Helpful. If you are happy that Close This Thread by Flag Correct Answer

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

Hi Martin

               you can use below function to get desire o/p:

               subfield('Blackberry 9900Seminovo Bom', ' ' ,-1)