topic Re: Multiple count in QlikView https://community.qlik.com/t5/QlikView/Multiple-count/m-p/503982#M1147525 <HTML><HEAD></HEAD><BODY><P>Something like these expressions maybe:</P><P></P><P>multiple: count({&lt;call_no={'=count(indent_no)&gt;1'}&gt;}distinct call_no)</P><P>single: count({&lt;call_no={'=count(indent_no)=1'}&gt;}distinct call_no)</P></BODY></HTML> Tue, 25 Jun 2013 10:07:46 GMT Gysbert_Wassenaar 2013-06-25T10:07:46Z Multiple count https://community.qlik.com/t5/QlikView/Multiple-count/m-p/503981#M1147524 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i have two table call_details &amp; Indent_details both are linked on call_no but for a single call there will be multiple indent_no. so how to find count of call_no having multiple indent_no and single indent_no (this is to find the multiple spare &amp; single spare calls count)</P><P></P><P>call_details&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Indent_details</P><P>call no&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; indent_no</P><P></P><P></P><P>Can anyone help me plz.</P><P></P><P>Regards,</P><P>Grace</P></BODY></HTML> Tue, 25 Jun 2013 03:47:45 GMT https://community.qlik.com/t5/QlikView/Multiple-count/m-p/503981#M1147524 2013-06-25T03:47:45Z Re: Multiple count https://community.qlik.com/t5/QlikView/Multiple-count/m-p/503982#M1147525 <HTML><HEAD></HEAD><BODY><P>Something like these expressions maybe:</P><P></P><P>multiple: count({&lt;call_no={'=count(indent_no)&gt;1'}&gt;}distinct call_no)</P><P>single: count({&lt;call_no={'=count(indent_no)=1'}&gt;}distinct call_no)</P></BODY></HTML> Tue, 25 Jun 2013 10:07:46 GMT https://community.qlik.com/t5/QlikView/Multiple-count/m-p/503982#M1147525 Gysbert_Wassenaar 2013-06-25T10:07:46Z