List box value limit.

[#1]

I have a list box with filed name Year and it has values from 1995 to 2020.(From the master calender)

I only want to display 2014,2103,2012,2011,2010 in the list box.How can I exclude other values from the lsit box ?

Thanks in advance.

[Luis_Cortizo]

There is no restrictions on the Listbox to show values beyond putting there an expression instead of a field. But that consumes resource innecesarily.

I'd create a new field on the MasterCalendar which would contain only those values (with a match or even an if statement) and use that field on the design layer.

Hope it helps.

Best regards.

[MK_QSL]

Write Down below expression in List Box Expression...

=IF(Year <= 2014 and Year >= 2010, Year)

[rustyfishbones]

Create a list box Expression

And Add this expression

IF(Year >= 2010 , Year)

[#5]

AS suggested by Luis its best if done while scripting. I have done it in both ways.

Check out the attached.

Thanks

AJ

[aveeeeeee7en]

Use Where Condition

eg.

Master Calendar:

Load

Year,

Month,

Quaerter,

MonthName,

FiscalYear

From Abc.qvd

Where Wildmatch(Year,'2014','2103','2012','2011','2010');

Or you can create a field in the Table:

eg.

Master Calendar:

Load

Year,

Month,

Quaerter,

MonthName,

FiscalYear,

if(Wildmatch(Year,'2014','2103','2012','2011','2010'),Year) AS YearNewField

From Abc.qvd;