topic Re: Specific value sum in field in QlikView https://community.qlik.com/t5/QlikView/Specific-value-sum-in-field/m-p/1341602#M413218 <HTML><HEAD></HEAD><BODY><P>You can do this number of ways. one way is simple</P><P><STRONG>Sum({&lt;[Header 3] = {''}&gt;}[Header 2])</STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166307_Capture.PNG" style="height: auto;" /></STRONG></P></BODY></HTML> Fri, 09 Jun 2017 06:53:14 GMT Anil_Babu_Samineni 2017-06-09T06:53:14Z Specific value sum in field https://community.qlik.com/t5/QlikView/Specific-value-sum-in-field/m-p/1341600#M413216 <HTML><HEAD></HEAD><BODY><P>Hello! Please help resolve the issue</P><P>I need to sum up the specific value in field.</P><P>For example, I need to find amount of "empty boxes" (Header 3) by summing up Header 2. </P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">Apple</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">Pine</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">40</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Kind regards,</P><P>Ruslan</P></BODY></HTML> Fri, 09 Jun 2017 06:40:02 GMT https://community.qlik.com/t5/QlikView/Specific-value-sum-in-field/m-p/1341600#M413216 rassanbekov 2017-06-09T06:40:02Z Re: Specific value sum in field https://community.qlik.com/t5/QlikView/Specific-value-sum-in-field/m-p/1341601#M413217 <HTML><HEAD></HEAD><BODY><P>Hi Ruslan,</P><P></P><P>Have a look at the attached file.</P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Fri, 09 Jun 2017 06:52:12 GMT https://community.qlik.com/t5/QlikView/Specific-value-sum-in-field/m-p/1341601#M413217 daveamz 2017-06-09T06:52:12Z Re: Specific value sum in field https://community.qlik.com/t5/QlikView/Specific-value-sum-in-field/m-p/1341602#M413218 <HTML><HEAD></HEAD><BODY><P>You can do this number of ways. one way is simple</P><P><STRONG>Sum({&lt;[Header 3] = {''}&gt;}[Header 2])</STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166307_Capture.PNG" style="height: auto;" /></STRONG></P></BODY></HTML> Fri, 09 Jun 2017 06:53:14 GMT https://community.qlik.com/t5/QlikView/Specific-value-sum-in-field/m-p/1341602#M413218 Anil_Babu_Samineni 2017-06-09T06:53:14Z