topic Re: Or condition in set analysis in QlikView https://community.qlik.com/t5/QlikView/Or-condition-in-set-analysis/m-p/1068072#M945127 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Count({$+&lt;[Assigned team] = p([Orginiate team])&gt;}Tickets)</STRONG></P></BODY></HTML> Tue, 12 Jan 2016 02:18:08 GMT sunny_talwar 2016-01-12T02:18:08Z Or condition in set analysis https://community.qlik.com/t5/QlikView/Or-condition-in-set-analysis/m-p/1068071#M945126 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i am facing an issue, i heave date pickers and two list boxes like as below.</P><TABLE border="1" class="jiveBorder" height="146" style="border: 1px solid rgb(0, 0, 0); width: 154px; height: 148px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Originate team</TH></TR><TR><TD style="padding: 2px;">ABC india</TD></TR><TR><TD style="padding: 2px;">ABC singapore</TD></TR><TR><TD style="padding: 2px;">cs india</TD></TR><TR><TD style="padding: 2px;">xyz </TD></TR></TBODY></TABLE><TABLE border="1" class="jiveBorder" height="152" style="border: 1px solid rgb(0, 0, 0); width: 150px; height: 154px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff;">Assigned team </STRONG></TH></TR><TR><TD style="padding: 2px;">ABC india</TD></TR><TR><TD style="padding: 2px;">MNO corp</TD></TR><TR><TD style="padding: 2px;">xyz ltd</TD></TR><TR><TD style="padding: 2px;">abc singapore</TD></TR><TR><TD style="padding: 2px;">KLM Prod</TD></TR></TBODY></TABLE><P></P><P>Issue: usually tickets are assigned to aaigned team and orinating by orginating team most of the tickets are handled by originating team.</P><P>but few tickets are handled by assigned team.</P><P>EXAMPLE: if i have 100 tickets assignd to ABC india and in that 90 tickets are handled by ABC india in originating team. remaining 10 tickets are handled by abc singapore.</P><P>Problem:&nbsp; i have given date range and when i select ABC india(Originating team) it is giving 90 tickets. but actual tickets are 100.</P><P></P><P>when i select ABC india i need count 100 how can i get please help me.</P><P></P><P></P><P>Thanks.</P></BODY></HTML> Tue, 12 Jan 2016 02:13:21 GMT https://community.qlik.com/t5/QlikView/Or-condition-in-set-analysis/m-p/1068071#M945126 2016-01-12T02:13:21Z Re: Or condition in set analysis https://community.qlik.com/t5/QlikView/Or-condition-in-set-analysis/m-p/1068072#M945127 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Count({$+&lt;[Assigned team] = p([Orginiate team])&gt;}Tickets)</STRONG></P></BODY></HTML> Tue, 12 Jan 2016 02:18:08 GMT https://community.qlik.com/t5/QlikView/Or-condition-in-set-analysis/m-p/1068072#M945127 sunny_talwar 2016-01-12T02:18:08Z