Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
aaronnayan
Contributor 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

Re: How to hide/exclude values from field in a listbox

You can use Expression like

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

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)
4 Replies

Re: How to hide/exclude values from field in a listbox

You can use Expression like

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

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)

Re: How to hide/exclude values from field in a listbox

Another option

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

Re: How to hide/exclude values from field in a listbox

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

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)

Re: How to hide/exclude values from field in a listbox