topic expression in QlikView https://community.qlik.com/t5/QlikView/expression/m-p/802540#M1044114 <HTML><HEAD></HEAD><BODY><P>=max({$&lt;[EMPNO]=&gt;} SAL)</P><P></P><P>i want to display on chart only (maximum&nbsp; salary).</P></BODY></HTML> Sat, 22 Nov 2014 18:04:13 GMT 2014-11-22T18:04:13Z expression https://community.qlik.com/t5/QlikView/expression/m-p/802540#M1044114 <HTML><HEAD></HEAD><BODY><P>=max({$&lt;[EMPNO]=&gt;} SAL)</P><P></P><P>i want to display on chart only (maximum&nbsp; salary).</P></BODY></HTML> Sat, 22 Nov 2014 18:04:13 GMT https://community.qlik.com/t5/QlikView/expression/m-p/802540#M1044114 2014-11-22T18:04:13Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/802541#M1044115 <HTML><HEAD></HEAD><BODY><P>How about </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Max ( TOTAL&nbsp; [<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SAL</SPAN>] )</P></BODY></HTML> Sat, 22 Nov 2014 18:11:25 GMT https://community.qlik.com/t5/QlikView/expression/m-p/802541#M1044115 Anonymous 2014-11-22T18:11:25Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/802542#M1044116 <HTML><HEAD></HEAD><BODY><P>firstsortedvalue(empno,-sal) for max </P><P></P><P>firstsortedvalue(empno,sal)&nbsp; for min</P></BODY></HTML> Sat, 22 Nov 2014 18:16:11 GMT https://community.qlik.com/t5/QlikView/expression/m-p/802542#M1044116 2014-11-22T18:16:11Z Re: expression https://community.qlik.com/t5/QlikView/expression/m-p/802543#M1044117 <HTML><HEAD></HEAD><BODY><P>Hi Hammad</P><P>You may try this-</P><P>max({1}Salary)</P><P>Here 1 is used as we have to calculate maximum salary from all employees irrespective of currently selected employee and $ is used for current selection.</P><P></P><P>Regards</P><P>Saurabh</P></BODY></HTML> Sat, 22 Nov 2014 18:42:58 GMT https://community.qlik.com/t5/QlikView/expression/m-p/802543#M1044117 2014-11-22T18:42:58Z