topic Maximum value in QlikView https://community.qlik.com/t5/QlikView/Maximum-value/m-p/481312#M1146200 <HTML><HEAD></HEAD><BODY><P>Hi Guys:</P><P>I am struggling with a problem, will appreciate your help</P><P></P><P>I have a straight table which looks like . E = V1 + V2,&nbsp; ER = E * 2</P><P></P><P>Months&nbsp;&nbsp; Category&nbsp;&nbsp;&nbsp; V1&nbsp; V2&nbsp; E&nbsp; ER</P><P>Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp; 20&nbsp;&nbsp; 30&nbsp;&nbsp; 60</P><P>Feb&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 5&nbsp;&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp; 50</P><P>Mar&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp; 4&nbsp;&nbsp; 34&nbsp;&nbsp;&nbsp; 68</P><P>April&nbsp;&nbsp; C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14</P><P></P><P>from this table , i need to get the Category which has maximum ER. then i need to plot both OE and OR on a line graph over months</P><P>I am not getting how to calculate max ER </P></BODY></HTML> Fri, 09 Aug 2013 14:02:52 GMT 2013-08-09T14:02:52Z Maximum value https://community.qlik.com/t5/QlikView/Maximum-value/m-p/481312#M1146200 <HTML><HEAD></HEAD><BODY><P>Hi Guys:</P><P>I am struggling with a problem, will appreciate your help</P><P></P><P>I have a straight table which looks like . E = V1 + V2,&nbsp; ER = E * 2</P><P></P><P>Months&nbsp;&nbsp; Category&nbsp;&nbsp;&nbsp; V1&nbsp; V2&nbsp; E&nbsp; ER</P><P>Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp; 20&nbsp;&nbsp; 30&nbsp;&nbsp; 60</P><P>Feb&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 5&nbsp;&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp; 50</P><P>Mar&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp; 4&nbsp;&nbsp; 34&nbsp;&nbsp;&nbsp; 68</P><P>April&nbsp;&nbsp; C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14</P><P></P><P>from this table , i need to get the Category which has maximum ER. then i need to plot both OE and OR on a line graph over months</P><P>I am not getting how to calculate max ER </P></BODY></HTML> Fri, 09 Aug 2013 14:02:52 GMT https://community.qlik.com/t5/QlikView/Maximum-value/m-p/481312#M1146200 2013-08-09T14:02:52Z