topic Expression issue in QlikView https://community.qlik.com/t5/QlikView/Expression-issue/m-p/1142018#M374051 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to write the expression for Sum of Top 5 order value by orderID in Text object</P></BODY></HTML> Wed, 25 May 2016 08:57:36 GMT 2016-05-25T08:57:36Z Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/1142018#M374051 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to write the expression for Sum of Top 5 order value by orderID in Text object</P></BODY></HTML> Wed, 25 May 2016 08:57:36 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/1142018#M374051 2016-05-25T08:57:36Z Re: Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/1142019#M374052 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P><STRONG><BR /></STRONG></P><P><STRONG>Sum({&lt;OrderID = {"=Rank(Sum([OrderValue])) &lt;= 5"}&gt;}OrderValue)</STRONG></P></BODY></HTML> Wed, 25 May 2016 09:42:50 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/1142019#M374052 sunny_talwar 2016-05-25T09:42:50Z Re: Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/1142020#M374053 <HTML><HEAD></HEAD><BODY><P>=sum({&lt;OrderID ={"=<STRONG>rank</STRONG>(sum(OrderValue),<STRONG>4</STRONG>) &lt;=5"}&gt;}<SPAN style="font-size: 13.3333px;">OrderValue</SPAN>)</P></BODY></HTML> Wed, 25 May 2016 09:49:03 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/1142020#M374053 Kushal_Chawda 2016-05-25T09:49:03Z