topic Intersection Data to Show on Chart in QlikView https://community.qlik.com/t5/QlikView/Intersection-Data-to-Show-on-Chart/m-p/583686#M545489 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a question about intersection.</P><P></P><P>Data example :</P><P></P><P>LOAD * INLINE [</P><P>CUSTOMER, PRODUCT</P><P>A, Z</P><P>A, X<BR />B, Z<BR />C, X<BR />D, Z</P><P>D, X<BR />D, Y</P><P>]</P><P></P><P>So this is the case, I have list box of Product and Straight Table with CUSTOMER as Dimension and Count(Product) as Expression</P><P></P><P>When I Choose Product Z, </P><P>then the table show</P><P>CUSTOMER, Count(PRODUCT)</P><P>A, 1</P><P>B, 1</P><P>D, 1</P><P></P><P>When I Choose Product Z and X, </P><P>then the table show</P><P>CUSTOMER, Count(PRODUCT)</P><P>A, 2</P><P>D, 2</P><P></P><P>(Because Customer A and D that bought Product Z and X)</P><P></P><P>When I Choose Product Z, X and Y, </P><P>then the table show </P><P>CUSTOMER, Count(PRODUCT)</P><P>D, 3</P><P></P><P>(Because only Customer D that bought Product Z, X and Y)</P><P></P><P>Thank you very much.</P></BODY></HTML> Tue, 01 Apr 2014 03:29:25 GMT 2014-04-01T03:29:25Z Intersection Data to Show on Chart https://community.qlik.com/t5/QlikView/Intersection-Data-to-Show-on-Chart/m-p/583686#M545489 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a question about intersection.</P><P></P><P>Data example :</P><P></P><P>LOAD * INLINE [</P><P>CUSTOMER, PRODUCT</P><P>A, Z</P><P>A, X<BR />B, Z<BR />C, X<BR />D, Z</P><P>D, X<BR />D, Y</P><P>]</P><P></P><P>So this is the case, I have list box of Product and Straight Table with CUSTOMER as Dimension and Count(Product) as Expression</P><P></P><P>When I Choose Product Z, </P><P>then the table show</P><P>CUSTOMER, Count(PRODUCT)</P><P>A, 1</P><P>B, 1</P><P>D, 1</P><P></P><P>When I Choose Product Z and X, </P><P>then the table show</P><P>CUSTOMER, Count(PRODUCT)</P><P>A, 2</P><P>D, 2</P><P></P><P>(Because Customer A and D that bought Product Z and X)</P><P></P><P>When I Choose Product Z, X and Y, </P><P>then the table show </P><P>CUSTOMER, Count(PRODUCT)</P><P>D, 3</P><P></P><P>(Because only Customer D that bought Product Z, X and Y)</P><P></P><P>Thank you very much.</P></BODY></HTML> Tue, 01 Apr 2014 03:29:25 GMT https://community.qlik.com/t5/QlikView/Intersection-Data-to-Show-on-Chart/m-p/583686#M545489 2014-04-01T03:29:25Z Re: Intersection Data to Show on Chart https://community.qlik.com/t5/QlikView/Intersection-Data-to-Show-on-Chart/m-p/583687#M545490 <HTML><HEAD></HEAD><BODY><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-5113">http://community.qlik.com/docs/DOC-5113</A></P><P></P><P>Please refer to this.</P></BODY></HTML> Tue, 01 Apr 2014 03:36:24 GMT https://community.qlik.com/t5/QlikView/Intersection-Data-to-Show-on-Chart/m-p/583687#M545490 2014-04-01T03:36:24Z