topic SELECT IN FIELD in QlikView https://community.qlik.com/t5/QlikView/SELECT-IN-FIELD/m-p/1267134#M857969 <HTML><HEAD></HEAD><BODY><P>I have the below list box with a trigger for Select in Field MAX(Month)</P><P></P><P>Can I take this a step further and have the last 3 values always selected.(Data is always updating) I saw a post that uses variables for latest and previous month using variables but can this be done without using variable?</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">MAX</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ENDDATE_YYYYMM</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/151448_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z SELECT IN FIELD https://community.qlik.com/t5/QlikView/SELECT-IN-FIELD/m-p/1267134#M857969 <HTML><HEAD></HEAD><BODY><P>I have the below list box with a trigger for Select in Field MAX(Month)</P><P></P><P>Can I take this a step further and have the last 3 values always selected.(Data is always updating) I saw a post that uses variables for latest and previous month using variables but can this be done without using variable?</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">MAX</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ENDDATE_YYYYMM</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/151448_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/SELECT-IN-FIELD/m-p/1267134#M857969 Anonymous 2020-11-25T16:16:04Z Re: SELECT IN FIELD https://community.qlik.com/t5/QlikView/SELECT-IN-FIELD/m-p/1267135#M857970 <HTML><HEAD></HEAD><BODY><P>may be with Firstsortedvalue() !</P></BODY></HTML> Tue, 31 Jan 2017 15:33:02 GMT https://community.qlik.com/t5/QlikView/SELECT-IN-FIELD/m-p/1267135#M857970 Anonymous 2017-01-31T15:33:02Z Re: SELECT IN FIELD https://community.qlik.com/t5/QlikView/SELECT-IN-FIELD/m-p/1267136#M857971 <HTML><HEAD></HEAD><BODY><P>What's the problem with variable</P><P></P><P>From here, What you want to select</P><P></P><P>May be this?</P><P></P><P><STRONG>Max(DateField,3)</STRONG></P></BODY></HTML> Tue, 31 Jan 2017 15:34:54 GMT https://community.qlik.com/t5/QlikView/SELECT-IN-FIELD/m-p/1267136#M857971 Anil_Babu_Samineni 2017-01-31T15:34:54Z Re: SELECT IN FIELD https://community.qlik.com/t5/QlikView/SELECT-IN-FIELD/m-p/1267137#M857972 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>='&gt;=' &amp; MAX(ENDDATE_YYYYMM, 3)</STRONG></P></BODY></HTML> Tue, 31 Jan 2017 15:36:29 GMT https://community.qlik.com/t5/QlikView/SELECT-IN-FIELD/m-p/1267137#M857972 sunny_talwar 2017-01-31T15:36:29Z