Solved: Filtering the displayed contents of a list Box - Qlik Community

Report Inappropriate Content · ‎2012-04-02

Can anyone tell me if it is possible to limit the contents of a list box to only display a sebset of values in a given field?

e.g I have a field containing 'year' which maybe contain values from 2001 through 2012. I wish to select from these in a list box - but rather than displaying the full 12 year range in the list box - I only want to display a choice of 2010, 2011,2012 ?

Thank You,

swuehl · ‎2012-04-02

You can use a field expression (at the very bottom of the field list in general tab of the list box properties, choose <expression>) and enter:

=if(year>=2010,year)

View solution in original post

swuehl · ‎2012-04-02

You can use a field expression (at the very bottom of the field list in general tab of the list box properties, choose <expression>) and enter:

=if(year>=2010,year)

Report Inappropriate Content · ‎2012-04-02

Perfect. Tks v much