topic How to calculate intersection customers amt? in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-intersection-customers-amt/m-p/507080#M189602 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I have a fact table as follow:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 293px;"><TBODY><TR><TD width="72">storeid</TD><TD width="93">customerid</TD><TD class="xl65" width="56">amt</TD></TR><TR><TD>store1</TD><TD>customer1</TD><TD align="right">100</TD></TR><TR><TD>store2</TD><TD>customer2</TD><TD align="right">50</TD></TR><TR><TD>store3</TD><TD>customer3</TD><TD align="right">70</TD></TR><TR><TD>store4</TD><TD>customer1</TD><TD align="right">60</TD></TR><TR><TD>store5</TD><TD>customer3</TD><TD align="right">130</TD></TR><TR><TD>store6</TD><TD>customer4</TD><TD align="right">80</TD></TR><TR><TD>store7</TD><TD>customer5</TD><TD align="right">90</TD></TR></TBODY></TABLE><P>The store 1-3 belong to group A and the store 4-7 belong to group B.</P><P>I want to calculate the amt of which customer bought from both group A &amp; B.</P><P>in this case means to calculate the amt of customer1 and customer3,</P><P>what expression should be used?</P></BODY></HTML> Wed, 11 Sep 2013 05:27:38 GMT 2013-09-11T05:27:38Z How to calculate intersection customers amt? https://community.qlik.com/t5/QlikView/How-to-calculate-intersection-customers-amt/m-p/507080#M189602 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I have a fact table as follow:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 293px;"><TBODY><TR><TD width="72">storeid</TD><TD width="93">customerid</TD><TD class="xl65" width="56">amt</TD></TR><TR><TD>store1</TD><TD>customer1</TD><TD align="right">100</TD></TR><TR><TD>store2</TD><TD>customer2</TD><TD align="right">50</TD></TR><TR><TD>store3</TD><TD>customer3</TD><TD align="right">70</TD></TR><TR><TD>store4</TD><TD>customer1</TD><TD align="right">60</TD></TR><TR><TD>store5</TD><TD>customer3</TD><TD align="right">130</TD></TR><TR><TD>store6</TD><TD>customer4</TD><TD align="right">80</TD></TR><TR><TD>store7</TD><TD>customer5</TD><TD align="right">90</TD></TR></TBODY></TABLE><P>The store 1-3 belong to group A and the store 4-7 belong to group B.</P><P>I want to calculate the amt of which customer bought from both group A &amp; B.</P><P>in this case means to calculate the amt of customer1 and customer3,</P><P>what expression should be used?</P></BODY></HTML> Wed, 11 Sep 2013 05:27:38 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-intersection-customers-amt/m-p/507080#M189602 2013-09-11T05:27:38Z Re: How to calculate intersection customers amt? https://community.qlik.com/t5/QlikView/How-to-calculate-intersection-customers-amt/m-p/507081#M189603 <HTML><HEAD></HEAD><BODY><P>May be using p() like in the attachment. PFA.</P></BODY></HTML> Wed, 11 Sep 2013 06:58:37 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-intersection-customers-amt/m-p/507081#M189603 tresB 2013-09-11T06:58:37Z Re: How to calculate intersection customers amt? https://community.qlik.com/t5/QlikView/How-to-calculate-intersection-customers-amt/m-p/507082#M189604 <HTML><HEAD></HEAD><BODY><P>Thank you very much,it works!<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 11 Sep 2013 07:08:42 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-intersection-customers-amt/m-p/507082#M189604 2013-09-11T07:08:42Z