topic Re: Automatically Select the Max Value from a Field in a Listbox in QlikView https://community.qlik.com/t5/QlikView/Automatically-Select-the-Max-Value-from-a-Field-in-a-Listbox/m-p/768257#M1023122 <HTML><HEAD></HEAD><BODY><P>Use this expr for ID_Month</P><P>=Aggr(MaxString(ID_MONTH),ID,ID_YEAR)</P></BODY></HTML> Mon, 09 Mar 2015 16:13:49 GMT anbu1984 2015-03-09T16:13:49Z Automatically Select the Max Value from a Field in a Listbox https://community.qlik.com/t5/QlikView/Automatically-Select-the-Max-Value-from-a-Field-in-a-Listbox/m-p/768256#M1023121 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following table:</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>ID</STRONG></SPAN></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>ID_YEAR</STRONG></SPAN></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>ID_MONTH</STRONG></SPAN></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">May</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Jun</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Jul</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Sep</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Oct</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Nov</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2013</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Dec</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Jan</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Apr</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">May</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Jun</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Jul</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Aug</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Sep</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Oct</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Nov</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Dec</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2015</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Jan</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2015</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Feb</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1021</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2015</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Mar</SPAN></TD></TR></TBODY></TABLE><P></P><P>Then I have:</P><P></P><UL><LI>1 Listbox with <STRONG>ID_YEAR</STRONG>: 2013 / 2014 / 2015</LI><LI>1 Listbox with <STRONG>ID_MONTH</STRONG>: Jan / Feb / Mar</LI><LI>1 Listbox with <STRONG>ID</STRONG>: 1021 / 1022 / 1023 / Etc</LI></UL><P></P><P><STRONG>ID_YEAR</STRONG> and <STRONG>ID_MONTH</STRONG> are part from a Master Calendar table and the <STRONG>ID</STRONG> conforms another table.</P><P></P><P>What I need is that when I select an <STRONG>ID</STRONG> from the <SPAN style="text-decoration: underline;">ID Listbox</SPAN> and the <STRONG>ID_YEAR</STRONG> from the <SPAN style="text-decoration: underline;">ID_YEAR</SPAN> Listbox, then automatically select the last month in the <SPAN style="text-decoration: underline;">ID_MONTH Listbox</SPAN> for the selected <STRONG>ID</STRONG>.</P><P></P><P>Do you know if that could be possible?</P><P></P><P>Thank you!!!</P></BODY></HTML> Mon, 09 Mar 2015 15:58:45 GMT https://community.qlik.com/t5/QlikView/Automatically-Select-the-Max-Value-from-a-Field-in-a-Listbox/m-p/768256#M1023121 microwin88x 2015-03-09T15:58:45Z Re: Automatically Select the Max Value from a Field in a Listbox https://community.qlik.com/t5/QlikView/Automatically-Select-the-Max-Value-from-a-Field-in-a-Listbox/m-p/768257#M1023122 <HTML><HEAD></HEAD><BODY><P>Use this expr for ID_Month</P><P>=Aggr(MaxString(ID_MONTH),ID,ID_YEAR)</P></BODY></HTML> Mon, 09 Mar 2015 16:13:49 GMT https://community.qlik.com/t5/QlikView/Automatically-Select-the-Max-Value-from-a-Field-in-a-Listbox/m-p/768257#M1023122 anbu1984 2015-03-09T16:13:49Z