Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

Show only like *OCO* in list box

I am trying to use Layout>Show>Conditional to show only field names in the list box with OCO in the string.

I tryed GetfieldSeletions([ABC]) like '*OCO*' but that means I have to select I just want to exclude everying without OCO in the field

How can do this?

3 Replies
m_woolf
Master II
Master II

Expression:

if(index(MyField,'OCO')>0,MyField)

tinkerz1
Creator II
Creator II
Author

Ok i tried this and it works

=if([MARKET RISK: NOTE: on target + overdue = LIVE ISSUES] LIKE '*OHL*',[MARKET RISK: NOTE: on target + overdue = LIVE ISSUES])

Then how can I automatically select them as they will be in a 'state'

Thanks

tinkerz1
Creator II
Creator II
Author

Sorry OCO was wrapped in a wildcard *OCO*