topic Re: Load max date for a row of data in App Development https://community.qlik.com/t5/App-Development/Load-max-date-for-a-row-of-data/m-p/1394213#M32217 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Date(RangeMax(Date1, Date2, Date3)) as MaxRowDate</STRONG></P></BODY></HTML> Mon, 28 Aug 2017 17:25:20 GMT sunny_talwar 2017-08-28T17:25:20Z Load max date for a row of data https://community.qlik.com/t5/App-Development/Load-max-date-for-a-row-of-data/m-p/1394212#M32216 <HTML><HEAD></HEAD><BODY><P>I am loading a table with some date fields in Qlik Sense:</P><P></P><P>LOAD </P><P>&nbsp; TRIM(DATE(Date1)), </P><P><SPAN style="font-size: 13.3333px;">&nbsp; TRIM(DATE(Date2</SPAN>)), </P><P>&nbsp; <SPAN style="font-size: 13.3333px;">TRIM(DATE(D</SPAN>ate3)) </P><P>FROM ...</P><P>;</P><P></P><P>I want to add 1 more field that holds the distinct maximum date from the 3 date fields above <SPAN style="text-decoration: underline;">for that row of data</SPAN>.</P><P></P><P>Each of these date fields (as well as the new maximum date field) can be null.</P><P></P><P>How do I do this?</P><P></P><P>Thank you.</P></BODY></HTML> Mon, 28 Aug 2017 17:12:09 GMT https://community.qlik.com/t5/App-Development/Load-max-date-for-a-row-of-data/m-p/1394212#M32216 2017-08-28T17:12:09Z Re: Load max date for a row of data https://community.qlik.com/t5/App-Development/Load-max-date-for-a-row-of-data/m-p/1394213#M32217 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Date(RangeMax(Date1, Date2, Date3)) as MaxRowDate</STRONG></P></BODY></HTML> Mon, 28 Aug 2017 17:25:20 GMT https://community.qlik.com/t5/App-Development/Load-max-date-for-a-row-of-data/m-p/1394213#M32217 sunny_talwar 2017-08-28T17:25:20Z Re: Load max date for a row of data https://community.qlik.com/t5/App-Development/Load-max-date-for-a-row-of-data/m-p/1394214#M32218 <HTML><HEAD></HEAD><BODY><P>This worked perfectly. Thank you so much!</P></BODY></HTML> Mon, 28 Aug 2017 17:47:56 GMT https://community.qlik.com/t5/App-Development/Load-max-date-for-a-row-of-data/m-p/1394214#M32218 2017-08-28T17:47:56Z