topic Use rangemax in QlikView https://community.qlik.com/t5/QlikView/Use-rangemax/m-p/281861#M1191264 <HTML><HEAD></HEAD><BODY><P>Hi everyone.</P><P></P><P>I am working in the margin now, I can calculate margin article one by one but not the total sales, I have two problems:</P><P>I take last contract price, it is 9999</P><P></P><P>SUM ({&lt; AÑOHASTA = {9999}&gt;} PRECIOCOMPRA)</P><P></P><P>But some articles have more than 1 price. I need to select the highest price. I´m trying wint RANGEMAX in set analysis but the result is null. </P><P>Can someone help me?</P></BODY></HTML> Thu, 18 Aug 2011 10:05:01 GMT 2011-08-18T10:05:01Z Use rangemax https://community.qlik.com/t5/QlikView/Use-rangemax/m-p/281861#M1191264 <HTML><HEAD></HEAD><BODY><P>Hi everyone.</P><P></P><P>I am working in the margin now, I can calculate margin article one by one but not the total sales, I have two problems:</P><P>I take last contract price, it is 9999</P><P></P><P>SUM ({&lt; AÑOHASTA = {9999}&gt;} PRECIOCOMPRA)</P><P></P><P>But some articles have more than 1 price. I need to select the highest price. I´m trying wint RANGEMAX in set analysis but the result is null. </P><P>Can someone help me?</P></BODY></HTML> Thu, 18 Aug 2011 10:05:01 GMT https://community.qlik.com/t5/QlikView/Use-rangemax/m-p/281861#M1191264 2011-08-18T10:05:01Z