Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
iktrayanov
Creator III
Creator III

Please see attached

View solution in original post

9 Replies
iktrayanov
Creator III
Creator III

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)

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

Attached is an example.

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

iktrayanov
Creator III
Creator III

Please see attached

Anonymous
Not applicable
Author

Ivan,

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

Tks..

Anonymous
Not applicable
Author

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.

iktrayanov
Creator III
Creator III

Try

If(FiscalYear>2013, FiscalYear)

If that Does not work you can try

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

iktrayanov
Creator III
Creator III

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

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

Anonymous
Not applicable
Author

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...