topic Re: Count Help Urgent...!!! in QlikView https://community.qlik.com/t5/QlikView/Count-Help-Urgent/m-p/402169#M1155592 <HTML><HEAD></HEAD><BODY><P>Thanks Bro...!!!</P></BODY></HTML> Thu, 28 Mar 2013 07:29:55 GMT 2013-03-28T07:29:55Z Count Help Urgent...!!! https://community.qlik.com/t5/QlikView/Count-Help-Urgent/m-p/402166#M1155589 <HTML><HEAD></HEAD><BODY><P>Hi Friends </P><P></P><P>Please check this table mentioned below:</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 841px;"><TBODY><TR><TD class="xl73" height="20" width="94">Batch Id</TD><TD class="xl71" width="113">Assigned To</TD><TD class="xl71" width="147">Date Assigned on</TD><TD class="xl71" width="159">Reviewer Assigned</TD><TD class="xl72" width="175">Status</TD><TD class="xl72" width="153">Document Type</TD></TR><TR><TD align="right" class="xl74" height="20">4992</TD><TD class="xl66" style="border-left: none;">Team 1</TD><TD class="xl67" style="border-left: none;">12-02-2013</TD><TD class="xl68" style="border-left: none;">Retwik Mukherjee </TD><TD class="xl68" style="border-left: none;">Completed</TD><TD class="xl68" style="border-left: none;">Out of Scope</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">4993</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Hage Oni </TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Out of Scope</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">4994</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Noshin Aarif</TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">MSA&nbsp; 1992</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">4995</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Sukanya Bhattacharyya</TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Amd to MSA</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">4996</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Retwik Mukherjee </TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Amd to MSA</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">4997</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Hage Oni </TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">MSA&nbsp; 1992</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">4998</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Noshin Aarif</TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Out of Scope</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">4999</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Sukanya Bhattacharyya</TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Out of Scope</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">5000</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Retwik Mukherjee </TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Novation Agreement</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">5001</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Hage Oni </TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Out of Scope</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">5002</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Noshin Aarif</TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Novation Agreement</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">5003</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Sukanya Bhattacharyya</TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Amd to MSA</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">5004</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Retwik Mukherjee </TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Amd to MSA</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">5005</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Hage Oni </TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Out of Scope</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">5006</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Noshin Aarif</TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Amd to MSA</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">5007</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Sukanya Bhattacharyya</TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Out of Scope</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">5008</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Retwik Mukherjee </TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Out of Scope</TD></TR><TR><TD align="right" class="xl74" height="20" style="border-top: none;">5009</TD><TD class="xl66" style="border-top: none; border-left: none;">Team 1</TD><TD class="xl67" style="border-top: none; border-left: none;">12-02-2013</TD><TD class="xl68" style="border-top: none; border-left: none;">Retwik Mukherjee </TD><TD class="xl68" style="border-top: none; border-left: none;">Completed</TD><TD class="xl68" style="border-top: none; border-left: none;">Out of Scope</TD></TR></TBODY></TABLE><P></P><P></P><P>I want to calculate <SPAN style="color: #ff0000;"><STRONG>count when status= Completed and&nbsp; document type = Out of Scope w.r.t. to Team 1&nbsp;&nbsp; </STRONG></SPAN></P><P></P><P></P><P><SPAN style="color: #ff0000;"><STRONG style="color: #000000;">Please help me how to give the condition . I'm trying this condition </STRONG></SPAN>count(if(<SPAN style="color: #ff0000;"><STRONG>status</STRONG></SPAN>)='<SPAN style="color: #ff0000;"><STRONG>Completed</STRONG></SPAN>' and if([<SPAN style="color: #ff0000;"><STRONG>document type]</STRONG></SPAN>)='<SPAN style="color: #ff0000;"><STRONG>Out of Scope'</STRONG></SPAN>)</P><P>but not getting any result....please help me out it's urgent...!!!</P></BODY></HTML> Thu, 28 Mar 2013 07:06:41 GMT https://community.qlik.com/t5/QlikView/Count-Help-Urgent/m-p/402166#M1155589 2013-03-28T07:06:41Z Re: Count Help Urgent...!!! https://community.qlik.com/t5/QlikView/Count-Help-Urgent/m-p/402167#M1155590 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try using this</P><P></P><P>count(if(status='Completed'&nbsp; and [document type]='Out of Scope',BatchId))</P><P></P><P></P><P>Regards</P><P>Amay</P></BODY></HTML> Thu, 28 Mar 2013 07:15:02 GMT https://community.qlik.com/t5/QlikView/Count-Help-Urgent/m-p/402167#M1155590 2013-03-28T07:15:02Z Re: Count Help Urgent...!!! https://community.qlik.com/t5/QlikView/Count-Help-Urgent/m-p/402168#M1155591 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Try this.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Count({&lt;Status = {"Completed"},Assigned_to = {"Team 1"},[Document Type] = {"Out of Scope"}&gt;} Filed1)</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Thu, 28 Mar 2013 07:16:54 GMT https://community.qlik.com/t5/QlikView/Count-Help-Urgent/m-p/402168#M1155591 kaushiknsolanki 2013-03-28T07:16:54Z Re: Count Help Urgent...!!! https://community.qlik.com/t5/QlikView/Count-Help-Urgent/m-p/402169#M1155592 <HTML><HEAD></HEAD><BODY><P>Thanks Bro...!!!</P></BODY></HTML> Thu, 28 Mar 2013 07:29:55 GMT https://community.qlik.com/t5/QlikView/Count-Help-Urgent/m-p/402169#M1155592 2013-03-28T07:29:55Z