Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
cacosta35
Contributor II

Is it possible to hide 2 items in a list box

Hello!

Is it possible to make 2 items invisible in a list box?  .... There are 5 items in my list box and I only want to show only 3 items and hide the other 2 items.

Thank You!

1 Solution

Accepted Solutions
Highlighted
iktrayanov
Contributor III

Re: Re: Is it possible to hide 2 items in a list box

Please see attached

View solution in original post

9 Replies
Highlighted
iktrayanov
Contributor III

Re: Is it possible to hide 2 items in a list box

Use expression like

If(match(YOURFIELD,'VALUE YOU WANT TO SHOW 1', 'VALUE YOU WANT TO SHOW 2','VALUE YOU WANT TO SHOW 3') > 0,YOURFIELD)

Highlighted
cacosta35
Contributor II

Re: Is it possible to hide 2 items in a list box

Hi! Ivan,

I tried adding the formula in the expression box but  the value I want to show were just added (makes a new column)  without losing the 5 original values...

So my  field showed up as

A  A

B  B

C  C

D  -

E  -

Instead of

A

B

C

Tks.

Highlighted
michael_gardner
Contributor III

Re: Re: Is it possible to hide 2 items in a list box

Attached is an example.

=IF(MATCH(Alphabet,'A','B','C'),Alphabet)

Highlighted
iktrayanov
Contributor III

Re: Re: Is it possible to hide 2 items in a list box

Please see attached

View solution in original post

Highlighted
cacosta35
Contributor II

Re: Re: Is it possible to hide 2 items in a list box

Ivan,

Thank you!  This one works now...I actually placed the formula in the expressions tab instead of the general tab...

Tks..

Highlighted
cacosta35
Contributor II

Re: Re: Is it possible to hide 2 items in a list box

Hi! Ivan,

I have a follow up question with the same scenario...What about if I want to filter the list of Fiscal Years in a list box?   I have a bunch of Fiscal Years listed from 2004-2015...And I only want to show the current Fiscal Year 2014 and forward of available.

Tks.

Highlighted
iktrayanov
Contributor III

Re: Re: Is it possible to hide 2 items in a list box

Try

If(FiscalYear>2013, FiscalYear)

If that Does not work you can try

=If(match(FiscalYear,'2014','2015')>0,FiscalYear)

Highlighted
iktrayanov
Contributor III

Re: Re: Is it possible to hide 2 items in a list box

If you don't want the current year hard coded try

If(FiscalYear>=year(today()), FiscalYear)

Highlighted
cacosta35
Contributor II

Re: Re: Is it possible to hide 2 items in a list box

Ivan,

Yes, this is what I want...I don't want it hard coded so I don't have to update every new year comes.

Thanks...