Setting default values in List box

[#1]

HI All,

I have selction for five years 2009,2010,2011,2012,2013.How to set default view for only two years current and previous (2012,2013) in an List box selection.

Can you please help me ASAP.

Thanks,

Rahul

[nizamsha]

=Max(Year)   &  '-'  &min(Year)-1

i thnk it will be useful 

[#3]

SET vMaxYear = Max(Year)

Load *

FROM$(SourceDir)Test.QVD
(qvd) Where Year > $(vMaxYear)-2;

[#4]

Hi,

Choosse edit expression from drop down of field list of list box. In that you can write

if(Year=max(Year) or Year=(max(Year)-1),Year) 

it will always take top two values always...

Hope it helps..

[#5]

Hi,

Choosse edit expression from drop down of field list of list box. In that you can write

if(Year=max(Year) or Year=(max(Year)-1),Year) 

it will always take top two values always...

Hope it helps..

[#6]

Hi All,

Thanks for you responses. Actually, i am looking for this .Whenever I come to this sheet i want to Activate only for current year and previous year. If user wants he can select whatever he wants.

[er_mohit · Accepted solution]

ok

right clik on that sheet --->Go to trigger tab-->

add action on ActiveSheet-->click -->Add-->selection-->select in field

then put YearFiledname above and in search string write (2012|2013)

then ok

hope it helps

[jagannalla]

To work dynamically use this code.

='('&Year(Today())&'|' &(Year(Today())-1)&')'

[ankitaag]

and what if when User selects any other filter and then click Clear All, Then what will be the selection. Trigger will not fire because it's on Activate sheet.

Any suggestions?

[#10]

Fantastic post... worked for me. Thanks