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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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