https://community.qlik.com/t5/QlikView/sum-with-condition/m-p/1818118#M1213199 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/100216">@entsh</a>&nbsp;</P><P>Try like below</P><P>Sum({&lt;row ={$(vreferto)}&gt;}number)</P><P>&nbsp;</P><P>vreferto =Concat(DISTINCT If(Len(Trim([refer to]))&gt;0, [refer to]), ',')</P><P>O/p:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MayilVahanan_0-1624777216352.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57619iA96548AC0187A4BA/image-size/medium?v=v2&amp;px=400" role="button" title="MayilVahanan_0-1624777216352.png" alt="MayilVahanan_0-1624777216352.png" /></span></P><P>&nbsp;</P> Sun, 27 Jun 2021 07:00:23 GMT MayilVahanan 2021-06-27T07:00:23Z https://community.qlik.com/t5/QlikView/sum-with-condition/m-p/1818102#M1213198 <P>hi</P><P>please consider below table:</P><P><FONT color="#000000">i want to sum all the row number but&nbsp; the numbers that mention in refer to column </FONT></P><TABLE border="1"><TBODY><TR><TD>row</TD><TD>number</TD><TD>refer to</TD></TR><TR><TD><FONT color="#FF0000">1</FONT></TD><TD>500</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD><FONT color="#FF9900">400</FONT></TD><TD><FONT color="#FF0000">1</FONT></TD></TR><TR><TD><FONT color="#FF0000">3</FONT></TD><TD>100</TD><TD><FONT color="#FF0000">1</FONT></TD></TR><TR><TD>4</TD><TD><FONT color="#FF9900">20</FONT></TD><TD><FONT color="#FF0000">3</FONT></TD></TR><TR><TD>5</TD><TD><FONT color="#FF9900">40</FONT></TD><TD>&nbsp;</TD></TR><TR><TD>6</TD><TD><FONT color="#FF9900">30</FONT></TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><FONT color="#FF6600">result =</FONT> 400+20+40+30=<FONT color="#FF6600">490</FONT></P><P><FONT color="#FF0000">explain :there are 2 unique&nbsp; numbers in refer to column ( 1 and 3) it means sum all the row number but 1 and 3</FONT></P><P>&nbsp;</P> Sun, 27 Jun 2021 05:08:40 GMT https://community.qlik.com/t5/QlikView/sum-with-condition/m-p/1818102#M1213198 entsh 2021-06-27T05:08:40Z https://community.qlik.com/t5/QlikView/sum-with-condition/m-p/1818118#M1213199 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/100216">@entsh</a>&nbsp;</P><P>Try like below</P><P>Sum({&lt;row ={$(vreferto)}&gt;}number)</P><P>&nbsp;</P><P>vreferto =Concat(DISTINCT If(Len(Trim([refer to]))&gt;0, [refer to]), ',')</P><P>O/p:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MayilVahanan_0-1624777216352.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57619iA96548AC0187A4BA/image-size/medium?v=v2&amp;px=400" role="button" title="MayilVahanan_0-1624777216352.png" alt="MayilVahanan_0-1624777216352.png" /></span></P><P>&nbsp;</P> Sun, 27 Jun 2021 07:00:23 GMT https://community.qlik.com/t5/QlikView/sum-with-condition/m-p/1818118#M1213199 MayilVahanan 2021-06-27T07:00:23Z