topic How to get minimum value across multiple fields in a single row? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-minimum-value-across-multiple-fields-in-a-single-row/m-p/162180#M35770 <HTML><HEAD></HEAD><BODY><P></P><P>Hey guys. So I have a table that has several (about 10) date fields. In the script, I want to create a derived field that is the earliest of those several date fields. I can't use the min function, which aggregates among rows. I want to look at a single row, and compare field A, B, C, ... and pick out the lowest value. Any ideas? Thanks!</P><P></P><P>Eric</P><BR /><BR /></BODY></HTML> Tue, 11 Jan 2011 00:04:08 GMT 2011-01-11T00:04:08Z How to get minimum value across multiple fields in a single row? https://community.qlik.com/t5/QlikView/How-to-get-minimum-value-across-multiple-fields-in-a-single-row/m-p/162180#M35770 <HTML><HEAD></HEAD><BODY><P></P><P>Hey guys. So I have a table that has several (about 10) date fields. In the script, I want to create a derived field that is the earliest of those several date fields. I can't use the min function, which aggregates among rows. I want to look at a single row, and compare field A, B, C, ... and pick out the lowest value. Any ideas? Thanks!</P><P></P><P>Eric</P><BR /><BR /></BODY></HTML> Tue, 11 Jan 2011 00:04:08 GMT https://community.qlik.com/t5/QlikView/How-to-get-minimum-value-across-multiple-fields-in-a-single-row/m-p/162180#M35770 2011-01-11T00:04:08Z How to get minimum value across multiple fields in a single row? https://community.qlik.com/t5/QlikView/How-to-get-minimum-value-across-multiple-fields-in-a-single-row/m-p/162181#M35771 <HTML><HEAD></HEAD><BODY><P>Use RangeMin and then apply function date() on top of it:</P><P></P><P>Date(RangeMin(Date1, Date2, Date3, ...))</P><P></P></BODY></HTML> Tue, 11 Jan 2011 00:17:52 GMT https://community.qlik.com/t5/QlikView/How-to-get-minimum-value-across-multiple-fields-in-a-single-row/m-p/162181#M35771 Oleg_Troyansky 2011-01-11T00:17:52Z