Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

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

Another option

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

Anil_Babu_Samineni

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