topic Re: Min and Max date from 8 different columns in QlikView https://community.qlik.com/t5/QlikView/Min-and-Max-date-from-8-different-columns/m-p/433775#M697903 <HTML><HEAD></HEAD><BODY><P>RANGEMIN(DATE,DATE,DATE,DATE, ....) AS FIRSTDATE</P><P></P><P>RANGEMAX(DATE,DATE,DATE,DATE, .... ) AS LASTDATE</P></BODY></HTML> Mon, 21 Jan 2013 20:43:38 GMT Michiel_QV_Fan 2013-01-21T20:43:38Z Min and Max date from 8 different columns https://community.qlik.com/t5/QlikView/Min-and-Max-date-from-8-different-columns/m-p/433771#M697899 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>How can I find the min date and the max date from my data?</P><P></P><P>I have 1 unique ID with 8 different date fields. Some fields are empty.</P><P></P><P>To fill my kalender right I need a single field with all unique possible dates from those 8 columns.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 18 Jan 2013 08:23:09 GMT https://community.qlik.com/t5/QlikView/Min-and-Max-date-from-8-different-columns/m-p/433771#M697899 Michiel_QV_Fan 2013-01-18T08:23:09Z Re: Min and Max date from 8 different columns https://community.qlik.com/t5/QlikView/Min-and-Max-date-from-8-different-columns/m-p/433772#M697900 <HTML><HEAD></HEAD><BODY><P>show this functiont ---&gt; FIRSTSORTVALUE.</P><P>bYE</P><P>mARCO</P></BODY></HTML> Fri, 18 Jan 2013 09:07:20 GMT https://community.qlik.com/t5/QlikView/Min-and-Max-date-from-8-different-columns/m-p/433772#M697900 2013-01-18T09:07:20Z Re: Min and Max date from 8 different columns https://community.qlik.com/t5/QlikView/Min-and-Max-date-from-8-different-columns/m-p/433773#M697901 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use "FIRSTSORTEDVALUE" function.</P><P></P><P>Min Date data: </P><P>Syntex = FirstSortedValue(fieldName,date)</P><P></P><P>Max Date data: </P><P>Syntex = FirstSortedValue(fieldName,-date)</P></BODY></HTML> Fri, 18 Jan 2013 09:21:07 GMT https://community.qlik.com/t5/QlikView/Min-and-Max-date-from-8-different-columns/m-p/433773#M697901 kumarnatarajan 2013-01-18T09:21:07Z Re: Min and Max date from 8 different columns https://community.qlik.com/t5/QlikView/Min-and-Max-date-from-8-different-columns/m-p/433774#M697902 <HTML><HEAD></HEAD><BODY><P>This isn't working because I have to evaluate 8 different columns.</P></BODY></HTML> Fri, 18 Jan 2013 11:56:36 GMT https://community.qlik.com/t5/QlikView/Min-and-Max-date-from-8-different-columns/m-p/433774#M697902 Michiel_QV_Fan 2013-01-18T11:56:36Z Re: Min and Max date from 8 different columns https://community.qlik.com/t5/QlikView/Min-and-Max-date-from-8-different-columns/m-p/433775#M697903 <HTML><HEAD></HEAD><BODY><P>RANGEMIN(DATE,DATE,DATE,DATE, ....) AS FIRSTDATE</P><P></P><P>RANGEMAX(DATE,DATE,DATE,DATE, .... ) AS LASTDATE</P></BODY></HTML> Mon, 21 Jan 2013 20:43:38 GMT https://community.qlik.com/t5/QlikView/Min-and-Max-date-from-8-different-columns/m-p/433775#M697903 Michiel_QV_Fan 2013-01-21T20:43:38Z