topic Sum if issue in App Development https://community.qlik.com/t5/App-Development/Sum-if-issue/m-p/1361018#M30535 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using Qlik Sense 3.2.4 and I have an issue with a sum If</P><P></P><TABLE border="1" class="jiveBorder" height="97" style="border: 1px solid #000000; width: 582px; height: 95px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Client Id</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product Category</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Limite<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>If(sum(Sales) &gt;= max(Limite),1,0) </STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">1</TD><TD style="padding: 2px; text-align: center;">Category 1</TD><TD style="padding: 2px; text-align: center;">7</TD><TD style="padding: 2px; text-align: center;">7</TD><TD style="padding: 2px; text-align: center;">1</TD></TR><TR><TD style="padding: 2px; text-align: center;">2</TD><TD style="padding: 2px; text-align: center;">Category 1</TD><TD style="padding: 2px; text-align: center;">6</TD><TD style="padding: 2px; text-align: center;">7</TD><TD style="padding: 2px; text-align: center;">0</TD></TR><TR><TD style="text-align: center;">3</TD><TD style="text-align: center;">Category 1</TD><TD style="text-align: center;">7</TD><TD style="text-align: center;">7</TD><TD style="text-align: center;">1</TD></TR><TR><TD style="text-align: center;">4</TD><TD style="text-align: center;"><SPAN style="font-size: 13.3333px; text-align: center;">Category 2</SPAN></TD><TD style="text-align: center;">5</TD><TD style="text-align: center;">5</TD><TD style="text-align: center;">1</TD></TR><TR><TD style="text-align: center;">5</TD><TD style="text-align: center;"><SPAN style="font-size: 13.3333px; text-align: center;">Category 2</SPAN></TD><TD style="text-align: center;">3</TD><TD style="text-align: center;">5</TD><TD style="text-align: center;">0</TD></TR></TBODY></TABLE><P></P><P>I would like to calculate the total of the last column by category but I can not figure out how to do this. </P><P>Category 1 = 2</P><P>Category 2 = 1</P><P></P><P>Is there anyone that could help me?</P><P></P><P>Thanks in advance for your help.</P><P></P><P>Best regards,</P><P>Nicolas</P></BODY></HTML> Mon, 10 Jul 2017 21:23:05 GMT nlr-biin_soluti 2017-07-10T21:23:05Z Sum if issue https://community.qlik.com/t5/App-Development/Sum-if-issue/m-p/1361018#M30535 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using Qlik Sense 3.2.4 and I have an issue with a sum If</P><P></P><TABLE border="1" class="jiveBorder" height="97" style="border: 1px solid #000000; width: 582px; height: 95px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Client Id</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product Category</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Limite<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>If(sum(Sales) &gt;= max(Limite),1,0) </STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">1</TD><TD style="padding: 2px; text-align: center;">Category 1</TD><TD style="padding: 2px; text-align: center;">7</TD><TD style="padding: 2px; text-align: center;">7</TD><TD style="padding: 2px; text-align: center;">1</TD></TR><TR><TD style="padding: 2px; text-align: center;">2</TD><TD style="padding: 2px; text-align: center;">Category 1</TD><TD style="padding: 2px; text-align: center;">6</TD><TD style="padding: 2px; text-align: center;">7</TD><TD style="padding: 2px; text-align: center;">0</TD></TR><TR><TD style="text-align: center;">3</TD><TD style="text-align: center;">Category 1</TD><TD style="text-align: center;">7</TD><TD style="text-align: center;">7</TD><TD style="text-align: center;">1</TD></TR><TR><TD style="text-align: center;">4</TD><TD style="text-align: center;"><SPAN style="font-size: 13.3333px; text-align: center;">Category 2</SPAN></TD><TD style="text-align: center;">5</TD><TD style="text-align: center;">5</TD><TD style="text-align: center;">1</TD></TR><TR><TD style="text-align: center;">5</TD><TD style="text-align: center;"><SPAN style="font-size: 13.3333px; text-align: center;">Category 2</SPAN></TD><TD style="text-align: center;">3</TD><TD style="text-align: center;">5</TD><TD style="text-align: center;">0</TD></TR></TBODY></TABLE><P></P><P>I would like to calculate the total of the last column by category but I can not figure out how to do this. </P><P>Category 1 = 2</P><P>Category 2 = 1</P><P></P><P>Is there anyone that could help me?</P><P></P><P>Thanks in advance for your help.</P><P></P><P>Best regards,</P><P>Nicolas</P></BODY></HTML> Mon, 10 Jul 2017 21:23:05 GMT https://community.qlik.com/t5/App-Development/Sum-if-issue/m-p/1361018#M30535 nlr-biin_soluti 2017-07-10T21:23:05Z Re: Sum if issue https://community.qlik.com/t5/App-Development/Sum-if-issue/m-p/1361019#M30536 <HTML><HEAD></HEAD><BODY><P>I just found how to do it.</P><P>Sum(Total if(aggr(sum(Sales, [Client Id]) &gt;= aggr(Max(Limite), [Client Id]), 1, 0))</P><P></P><P>Nicolas</P></BODY></HTML> Mon, 10 Jul 2017 21:37:58 GMT https://community.qlik.com/t5/App-Development/Sum-if-issue/m-p/1361019#M30536 nlr-biin_soluti 2017-07-10T21:37:58Z