https://community.qlik.com/t5/QlikView/How-to-write-the-expression-in-KPI/m-p/1684139#M455832 <P>Thanks Sunny , Its Working&nbsp;</P> Thu, 12 Mar 2020 12:42:50 GMT kunkumnaveen 2020-03-12T12:42:50Z https://community.qlik.com/t5/QlikView/How-to-write-the-expression-in-KPI/m-p/1682847#M455828 <P>Hello All</P><P>I need to show the <STRONG>sum</STRONG> of below red colored rounded values in <STRONG>KPI</STRONG></P><P>which is <STRONG>9345+4915+3109+2172=</STRONG></P><P><STRONG>Dimension : base_model</STRONG></P><P><STRONG>Expression&nbsp; In Table :&nbsp;</STRONG></P><P>if(<BR />rangesum(above(sum(d_OP)<BR />/<BR />sum(total d_OP),0,rowno()))&lt;.80,sum(d_OP),0)</P><P>&nbsp;</P><P><STRONG>Expression In KPI (Tried but not worked <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></STRONG></P><P>&nbsp;</P><P>sum(aggr(</P><P>if(<BR />rangesum(above(sum(d_OP)<BR />/<BR />sum(total d_OP),0,rowno()))&lt;.80,sum(d_OP),0)(base_model,(NUMERIC))))</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 774px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/29748iFB01D370F16E9148/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>What am i missing in above KPI expression ?</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P> Mon, 09 Mar 2020 11:49:51 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression-in-KPI/m-p/1682847#M455828 kunkumnaveen 2020-03-09T11:49:51Z https://community.qlik.com/t5/QlikView/How-to-write-the-expression-in-KPI/m-p/1683189#M455829 <P>Still I couldn't find solution for the above requirement.</P><P>Any suggestions form you guys</P><P>&nbsp;</P><P>Thanks</P> Tue, 10 Mar 2020 10:24:29 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression-in-KPI/m-p/1683189#M455829 kunkumnaveen 2020-03-10T10:24:29Z https://community.qlik.com/t5/QlikView/How-to-write-the-expression-in-KPI/m-p/1684121#M455830 <P>Any Suggestion on above requirement ,as i don't have any other source,so i m trying to find the solution over here</P> Thu, 12 Mar 2020 11:55:50 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression-in-KPI/m-p/1684121#M455830 kunkumnaveen 2020-03-12T11:55:50Z https://community.qlik.com/t5/QlikView/How-to-write-the-expression-in-KPI/m-p/1684126#M455831 <P>Try this</P><LI-CODE lang="markup">Sum(Aggr( If(RangeSum(Above(Sum(d_OP)/Sum(TOTAL d_OP), 0, RowNo())) &lt; 0.80, Sum(d_OP), 0) , (base_model, (=Sum(d_OP), DESC))))</LI-CODE> Thu, 12 Mar 2020 12:16:12 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression-in-KPI/m-p/1684126#M455831 sunny_talwar 2020-03-12T12:16:12Z https://community.qlik.com/t5/QlikView/How-to-write-the-expression-in-KPI/m-p/1684139#M455832 <P>Thanks Sunny , Its Working&nbsp;</P> Thu, 12 Mar 2020 12:42:50 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression-in-KPI/m-p/1684139#M455832 kunkumnaveen 2020-03-12T12:42:50Z https://community.qlik.com/t5/QlikView/How-to-write-the-expression-in-KPI/m-p/1684141#M455833 <P>Awesome!!</P> Thu, 12 Mar 2020 12:44:42 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-expression-in-KPI/m-p/1684141#M455833 sunny_talwar 2020-03-12T12:44:42Z