topic Max year in QlikView https://community.qlik.com/t5/QlikView/Max-year/m-p/1040252#M466445 <HTML><HEAD></HEAD><BODY><P>i have a question.</P><P></P><P></P><P>We have a table containing, amongst other fields, a property code, a value at a specific date, a date, a month and a year field</P><P>we want to select the value of the PROP_UNIT_ARE field on a date that has been selected in the calender.</P><P>we're using the this statement;&nbsp; max({$&lt;Year={'&gt;=$(PROP_UNIT_DATE_YEAR)'}&gt;}PROP_UNIT_AREA)&nbsp; </P><P></P><P>A sample file is attached.</P><P></P><P>Anyone have a clue?</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 03 Feb 2016 13:30:46 GMT 2016-02-03T13:30:46Z Max year https://community.qlik.com/t5/QlikView/Max-year/m-p/1040252#M466445 <HTML><HEAD></HEAD><BODY><P>i have a question.</P><P></P><P></P><P>We have a table containing, amongst other fields, a property code, a value at a specific date, a date, a month and a year field</P><P>we want to select the value of the PROP_UNIT_ARE field on a date that has been selected in the calender.</P><P>we're using the this statement;&nbsp; max({$&lt;Year={'&gt;=$(PROP_UNIT_DATE_YEAR)'}&gt;}PROP_UNIT_AREA)&nbsp; </P><P></P><P>A sample file is attached.</P><P></P><P>Anyone have a clue?</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 03 Feb 2016 13:30:46 GMT https://community.qlik.com/t5/QlikView/Max-year/m-p/1040252#M466445 2016-02-03T13:30:46Z