topic Sumif function in qlikview in QlikView https://community.qlik.com/t5/QlikView/Sumif-function-in-qlikview/m-p/1177774#M889470 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>As mentioned below result i required the same in Qlikview.</P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 445px;"><TBODY><TR><TD class="xl65" height="17" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);" width="50">Cust_id</TD><TD class="xl65" style="border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);" width="110">Membername</TD><TD class="xl65" style="border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);" width="77">claimamount</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">SUMIF($A$1:$A$11,A1,$C$1:$C$11)</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802219</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Kishorbhai Soneji </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">41682</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">43364</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802228</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Sahina Pathan </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">29673</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">29673</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802545</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Ranjanben </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">6672</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">6672</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802557</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Motilal Kanjani&nbsp;&nbsp; </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">24690</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">27159</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802558</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Kala Devi </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">9643</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">9643</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802581</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">B Shiva Nayak&nbsp;&nbsp; </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">14848</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">14848</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802592</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">K Devi Kumari&nbsp;&nbsp; </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">33000</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">33000</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802617</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Jacob K Thomas&nbsp;&nbsp; </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">14578</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">14578</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802557</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Motilal Kanjani&nbsp;&nbsp; </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">2469</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">27159</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802219</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Kishorbhai Soneji </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">1682</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">43364</TH></TR></TBODY></TABLE><P></P><P>Thanks in Advance..</P><P></P><P>Rgrds,</P><P>Rafi.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Sumif function in qlikview https://community.qlik.com/t5/QlikView/Sumif-function-in-qlikview/m-p/1177774#M889470 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>As mentioned below result i required the same in Qlikview.</P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 445px;"><TBODY><TR><TD class="xl65" height="17" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);" width="50">Cust_id</TD><TD class="xl65" style="border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);" width="110">Membername</TD><TD class="xl65" style="border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);" width="77">claimamount</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">SUMIF($A$1:$A$11,A1,$C$1:$C$11)</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802219</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Kishorbhai Soneji </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">41682</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">43364</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802228</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Sahina Pathan </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">29673</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">29673</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802545</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Ranjanben </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">6672</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">6672</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802557</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Motilal Kanjani&nbsp;&nbsp; </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">24690</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">27159</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802558</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Kala Devi </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">9643</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">9643</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802581</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">B Shiva Nayak&nbsp;&nbsp; </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">14848</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">14848</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802592</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">K Devi Kumari&nbsp;&nbsp; </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">33000</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">33000</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802617</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Jacob K Thomas&nbsp;&nbsp; </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">14578</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">14578</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802557</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Motilal Kanjani&nbsp;&nbsp; </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">2469</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">27159</TH></TR><TR><TD align="right" class="xl67" height="17" style="border-top: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">802219</TD><TD class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Kishorbhai Soneji </TD><TD align="right" class="xl67" style="border-top: none; border-left: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">1682</TD><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">43364</TH></TR></TBODY></TABLE><P></P><P>Thanks in Advance..</P><P></P><P>Rgrds,</P><P>Rafi.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sumif-function-in-qlikview/m-p/1177774#M889470 Anonymous 2020-11-25T16:16:04Z Re: Sumif function in qlikview https://community.qlik.com/t5/QlikView/Sumif-function-in-qlikview/m-p/1177775#M889471 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Sum(TOTAL &lt;Cust_id&gt; claimamount)</STRONG></P></BODY></HTML> Fri, 26 Aug 2016 12:52:37 GMT https://community.qlik.com/t5/QlikView/Sumif-function-in-qlikview/m-p/1177775#M889471 sunny_talwar 2016-08-26T12:52:37Z Re: Sumif function in qlikview https://community.qlik.com/t5/QlikView/Sumif-function-in-qlikview/m-p/1177776#M889472 <HTML><HEAD></HEAD><BODY><P>Try this </P><P></P><P>Aggr(sum(<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">claimamount</STRONG>),<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">Cust_id,<SPAN style="font-size: 13px;">Membername</SPAN></STRONG>)</P></BODY></HTML> Fri, 26 Aug 2016 12:56:48 GMT https://community.qlik.com/t5/QlikView/Sumif-function-in-qlikview/m-p/1177776#M889472 avinashelite 2016-08-26T12:56:48Z Re: Sumif function in qlikview https://community.qlik.com/t5/QlikView/Sumif-function-in-qlikview/m-p/1177777#M889473 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please read this</P><P></P><P><A href="https://community.qlikview.com/thread/74494" title="https://community.qlikview.com/thread/74494">When is it best to use sum(if()) over Set Analy... | Qlik Community</A></P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">My guess: Aggr(sum(</SPAN>claimamount<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">),</SPAN>Cust_id<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">)</SPAN></P><P></P><P>HTH</P><P></P><P>André Gomes</P></BODY></HTML> Fri, 26 Aug 2016 13:06:04 GMT https://community.qlik.com/t5/QlikView/Sumif-function-in-qlikview/m-p/1177777#M889473 agomes1971 2016-08-26T13:06:04Z