topic Restricting/hiding list box values in QlikView

Restricting/hiding list box values

Sat, 19 Jan 2013 08:21:21 GMT

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

Sat, 19 Jan 2013 09:43:04 GMT

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.

Fri, 19 Apr 2013 09:00:20 GMT

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!