Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
aaronnayan
Creator III
Creator III

How to hide/exclude values from field in a listbox

Hi guys

I want to hide/exclude certain values from a list box

What expression can i use to only show hoodies and jumpers?


Field:   Clothing

          T-shirts

        Jeans

          Trainers

          Hoodies

        Jumpers

Labels (1)
1 Solution

Accepted Solutions
Anil_Babu_Samineni
MVP
MVP

You can use Expression like

If(Match(Clothing, 'hoodies','jumpers'), Clothing)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

4 Replies
Anil_Babu_Samineni
MVP
MVP

You can use Expression like

If(Match(Clothing, 'hoodies','jumpers'), Clothing)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar
MVP
MVP

Another option

Aggr(Only({1<Clothing = {'Hoodies','Jumpers'}>} Clothing), Clothing)

Anil_Babu_Samineni
MVP
MVP

I like your nature because you always come up with different approach. Thanks Bhaiah

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar
MVP
MVP