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: 
Not applicable

Restricting/hiding list box values

Hi all

I have a YEAR dimension like this :

Year ( Booking_Date) as Year

Field Values are 2006,2007,2008,2009,2010.

When I add this list box to the sheet, if I want to see all year's accept 2010 in list box …how I can do this ??

                                                  (i.e 2006,2007,2008,2009)

Many thanks

1 Solution

Accepted Solutions
Not applicable
Author

Shariq,

Go to the List Box properties and under the Field column dropdown, Select Expression.

Add expression as:

=aggr(only({<Year-={2010}>}Year),Year)

Please see the attached sample.

Hope it helps.

Regards,

-Khaled.

View solution in original post

2 Replies
Not applicable
Author

Shariq,

Go to the List Box properties and under the Field column dropdown, Select Expression.

Add expression as:

=aggr(only({<Year-={2010}>}Year),Year)

Please see the attached sample.

Hope it helps.

Regards,

-Khaled.

Not applicable
Author

Hello everyboy,

I have a similar question as Shariq.

I have a listbox with 30 or so values which I want to limit to 20. This means that only these 20 values should be pre-selected. Is this possible?

Thank you!