topic Re: Select in Field not working in QlikView https://community.qlik.com/t5/QlikView/Select-in-Field-not-working/m-p/495018#M185153 <HTML><HEAD></HEAD><BODY><P>Nicole understood your question better than I did.&nbsp; I thought you wanted it to happen on every sheet.</P><P></P><P>Go with her answer.</P></BODY></HTML> Tue, 26 Nov 2013 18:57:46 GMT greg-anderson 2013-11-26T18:57:46Z Select in Field not working https://community.qlik.com/t5/QlikView/Select-in-Field-not-working/m-p/495015#M185150 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Tue, 26 Nov 2013 18:43:38 GMT https://community.qlik.com/t5/QlikView/Select-in-Field-not-working/m-p/495015#M185150 2013-11-26T18:43:38Z Re: Select in Field not working https://community.qlik.com/t5/QlikView/Select-in-Field-not-working/m-p/495016#M185151 <HTML><HEAD></HEAD><BODY><P>You'll need to set a similar trigger on every tab.</P><P></P><P>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).</P></BODY></HTML> Tue, 26 Nov 2013 18:46:06 GMT https://community.qlik.com/t5/QlikView/Select-in-Field-not-working/m-p/495016#M185151 greg-anderson 2013-11-26T18:46:06Z Re: Select in Field not working https://community.qlik.com/t5/QlikView/Select-in-Field-not-working/m-p/495017#M185152 <HTML><HEAD></HEAD><BODY><P>Make your select in field Max({1}Year).</P></BODY></HTML> Tue, 26 Nov 2013 18:46:56 GMT https://community.qlik.com/t5/QlikView/Select-in-Field-not-working/m-p/495017#M185152 Nicole-Smith 2013-11-26T18:46:56Z Re: Select in Field not working https://community.qlik.com/t5/QlikView/Select-in-Field-not-working/m-p/495018#M185153 <HTML><HEAD></HEAD><BODY><P>Nicole understood your question better than I did.&nbsp; I thought you wanted it to happen on every sheet.</P><P></P><P>Go with her answer.</P></BODY></HTML> Tue, 26 Nov 2013 18:57:46 GMT https://community.qlik.com/t5/QlikView/Select-in-Field-not-working/m-p/495018#M185153 greg-anderson 2013-11-26T18:57:46Z Re: Select in Field not working https://community.qlik.com/t5/QlikView/Select-in-Field-not-working/m-p/495019#M185154 <HTML><HEAD></HEAD><BODY><P>Perfect! Thanks.</P></BODY></HTML> Tue, 26 Nov 2013 20:01:39 GMT https://community.qlik.com/t5/QlikView/Select-in-Field-not-working/m-p/495019#M185154 2013-11-26T20:01:39Z