Select in Field not working

[#1]

I have a list box 'Year' with values 2013, 2012 and so on. Whenever I activate the sheet, I want it to show the latest year (2013). I created a trigger with "Select in Field" and set it to Max(Year). It works fine when there are no selections on the Year field. But when there is a selection (say the Year is set to 2011), and when I navigate to a different sheet and activate this sheet, it still shows 2011. How do I make it show 2013?

[greg-anderson]

You'll need to set a similar trigger on every tab.

Qlikview will always carry your selections throughout the document, unless you get into alternate states and set analysis (which I don't think you need here).

[Nicole-Smith · Accepted solution]

Make your select in field Max({1}Year).

[greg-anderson]

Nicole understood your question better than I did.  I thought you wanted it to happen on every sheet.

Go with her answer.

[#5]

Perfect! Thanks.