topic Re: How to count 2 independent variables? in QlikView https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919362#M982994 <HTML><HEAD></HEAD><BODY><P>The count should be "Destinatario" and "Document". E.G; The first client named "ZAIDA" has 3 different documents, so the answer should be 3.</P><P><IMG __jive_id="95671" alt="Imagen1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95671_Imagen1.png" style="height: 183px; width: 620px;" /></P></BODY></HTML> Tue, 11 Aug 2015 16:38:54 GMT 2015-08-11T16:38:54Z How to count 2 independent variables? https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919360#M982992 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P>I have a list of purchases per client and every transaction comes with different products. I need to count as one every transaction per client independently of the quantity. Needless to say, if a customer purchases 2 times, the answer should be 2</P><P></P><P>Thanks</P></BODY></HTML> Tue, 11 Aug 2015 16:25:09 GMT https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919360#M982992 2015-08-11T16:25:09Z Re: How to count 2 independent variables? https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919361#M982993 <HTML><HEAD></HEAD><BODY><P>post sample data please so can help.</P></BODY></HTML> Tue, 11 Aug 2015 16:27:40 GMT https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919361#M982993 Anonymous 2015-08-11T16:27:40Z Re: How to count 2 independent variables? https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919362#M982994 <HTML><HEAD></HEAD><BODY><P>The count should be "Destinatario" and "Document". E.G; The first client named "ZAIDA" has 3 different documents, so the answer should be 3.</P><P><IMG __jive_id="95671" alt="Imagen1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95671_Imagen1.png" style="height: 183px; width: 620px;" /></P></BODY></HTML> Tue, 11 Aug 2015 16:38:54 GMT https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919362#M982994 2015-08-11T16:38:54Z Re: How to count 2 independent variables? https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919363#M982995 <HTML><HEAD></HEAD><BODY><P>Try,</P><P>Aggr(Count(Documents),Destinatario)</P></BODY></HTML> Tue, 11 Aug 2015 16:49:45 GMT https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919363#M982995 settu_periasamy 2015-08-11T16:49:45Z Re: How to count 2 independent variables? https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919364#M982996 <HTML><HEAD></HEAD><BODY><P>This example is even better, theres 1 customer and 1 document, but 8 different products, and the answer should be 1</P><P><IMG alt="Imagen2.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95672_Imagen2.png" style="height: 94px; width: 620px;" /></P></BODY></HTML> Tue, 11 Aug 2015 16:51:11 GMT https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919364#M982996 2015-08-11T16:51:11Z Re: How to count 2 independent variables? https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919365#M982997 <HTML><HEAD></HEAD><BODY><P>didn't worked</P></BODY></HTML> Tue, 11 Aug 2015 16:54:09 GMT https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919365#M982997 2015-08-11T16:54:09Z Re: How to count 2 independent variables? https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919366#M982998 <HTML><HEAD></HEAD><BODY><P>maybe try:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">Aggr(Count(Documents),Cliente)</SPAN></P></BODY></HTML> Tue, 11 Aug 2015 16:56:45 GMT https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919366#M982998 Anonymous 2015-08-11T16:56:45Z Re: How to count 2 independent variables? https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919367#M982999 <HTML><HEAD></HEAD><BODY><P>Still 8</P></BODY></HTML> Tue, 11 Aug 2015 17:01:45 GMT https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919367#M982999 2015-08-11T17:01:45Z Re: How to count 2 independent variables? https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919368#M983000 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">Aggr(Count(Distinct Documents),Cliente)</SPAN></P></BODY></HTML> Tue, 11 Aug 2015 17:08:59 GMT https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919368#M983000 Anonymous 2015-08-11T17:08:59Z Re: How to count 2 independent variables? https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919369#M983001 <HTML><HEAD></HEAD><BODY><P>Doesn't work</P></BODY></HTML> Thu, 13 Aug 2015 15:16:36 GMT https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919369#M983001 2015-08-13T15:16:36Z Re: How to count 2 independent variables? https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919370#M983002 <HTML><HEAD></HEAD><BODY><P>Hi Benjamin,</P><P></P><P>pleas can you load sample data,so can help.</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Thanks &amp; Regards</SPAN></P><P>Neetha</P></BODY></HTML> Thu, 13 Aug 2015 15:21:56 GMT https://community.qlik.com/t5/QlikView/How-to-count-2-independent-variables/m-p/919370#M983002 Anonymous 2015-08-13T15:21:56Z