https://community.qlik.com/t5/App-Development/How-to-write-the-expression-in-KPI/m-p/1669992#M51610 <P>Thanks Sunny,It is working&nbsp;</P> Tue, 28 Jan 2020 11:38:15 GMT kunkumnaveen 2020-01-28T11:38:15Z https://community.qlik.com/t5/App-Development/How-to-write-the-expression-in-KPI/m-p/1669983#M51608 <P>Hello All ,</P><P>From the below image , i need to show &nbsp;the last two columns<STRONG> &nbsp;cumulative sum in two different KPI</STRONG>&nbsp;,</P><P>KPI1: &nbsp;<STRONG>sum(8223+4040+1507)</STRONG></P><P>KPI2: <STRONG>sum(0+4040+3014)</STRONG></P><P>Selection Year,Month</P><P>Dimension:Cycle_2</P><P>expression (Last but one cloumn):&nbsp;</P><P><STRONG>if(</STRONG><BR /><STRONG>rangesum(above(count(Cycle_2)</STRONG><BR /><STRONG>/</STRONG><BR /><STRONG>count(total Cycle_2),0,rowno()))&lt;.95,count(Cycle_2),0)</STRONG></P><P><STRONG>,</STRONG></P><P>&nbsp;</P><P>Expression(Last Column) :&nbsp;</P><P><STRONG>if(</STRONG><BR /><STRONG>rangesum(above(count(Cycle_2)</STRONG><BR /><STRONG>/</STRONG><BR /><STRONG>count(total Cycle_2),0,rowno()))&lt;.95,Cycle_2*count(Cycle_2),0)</STRONG><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/27551iBCBEC1261F74CA54/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>Thanks</P> Tue, 28 Jan 2020 11:25:05 GMT https://community.qlik.com/t5/App-Development/How-to-write-the-expression-in-KPI/m-p/1669983#M51608 kunkumnaveen 2020-01-28T11:25:05Z https://community.qlik.com/t5/App-Development/How-to-write-the-expression-in-KPI/m-p/1669986#M51609 <P>What is the dimension of your chart below? Is it called Cycle_2? If it is, then try something like this</P><LI-CODE lang="markup">Sum(Aggr( If(RangeSum(Above(Count(Cycle_2)/Count(TOTAL Cycle_2), 0, RowNo())) &lt; 0.95, Count(Cycle_2), 0) , (Cycle_2, (NUMERIC))))</LI-CODE> Tue, 28 Jan 2020 11:33:00 GMT https://community.qlik.com/t5/App-Development/How-to-write-the-expression-in-KPI/m-p/1669986#M51609 sunny_talwar 2020-01-28T11:33:00Z https://community.qlik.com/t5/App-Development/How-to-write-the-expression-in-KPI/m-p/1669992#M51610 <P>Thanks Sunny,It is working&nbsp;</P> Tue, 28 Jan 2020 11:38:15 GMT https://community.qlik.com/t5/App-Development/How-to-write-the-expression-in-KPI/m-p/1669992#M51610 kunkumnaveen 2020-01-28T11:38:15Z