topic Calculated Column Count IF Help (Straight Table) in QlikView https://community.qlik.com/t5/QlikView/Calculated-Column-Count-IF-Help-Straight-Table/m-p/930888#M967418 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to create a straight table that basically counts the amount of Manual and Automated payments, per Relationship Manager</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>RM</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Manual</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Automated</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Manual AT</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Automated AT</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>Joe</P></TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD></TR><TR><TD style="padding: 2px;">Bill</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD></TR><TR><TD style="padding: 2px;">Fred</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD></TR><TR><TD style="padding: 2px;">Steve</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD></TR></TBODY></TABLE><P></P><P>Issue is, the data is brought back in a single field 'Manual/Automated' so I can't do a simple count and am struggling to make it count the number of times each comes up by putting an IF on it. Also, I'm unsure if it will filter down by RM.</P><P></P><P>Hope that makes sense.</P><P></P><P>Thanks,</P><P></P><P>Luke</P></BODY></HTML> Thu, 24 Sep 2015 09:43:02 GMT 2015-09-24T09:43:02Z Calculated Column Count IF Help (Straight Table) https://community.qlik.com/t5/QlikView/Calculated-Column-Count-IF-Help-Straight-Table/m-p/930888#M967418 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to create a straight table that basically counts the amount of Manual and Automated payments, per Relationship Manager</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>RM</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Manual</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Automated</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Manual AT</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Automated AT</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>Joe</P></TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD></TR><TR><TD style="padding: 2px;">Bill</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD></TR><TR><TD style="padding: 2px;">Fred</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD></TR><TR><TD style="padding: 2px;">Steve</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD><TD style="padding: 2px;">?</TD></TR></TBODY></TABLE><P></P><P>Issue is, the data is brought back in a single field 'Manual/Automated' so I can't do a simple count and am struggling to make it count the number of times each comes up by putting an IF on it. Also, I'm unsure if it will filter down by RM.</P><P></P><P>Hope that makes sense.</P><P></P><P>Thanks,</P><P></P><P>Luke</P></BODY></HTML> Thu, 24 Sep 2015 09:43:02 GMT https://community.qlik.com/t5/QlikView/Calculated-Column-Count-IF-Help-Straight-Table/m-p/930888#M967418 2015-09-24T09:43:02Z