Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a question about intersection.
Data example :
LOAD * INLINE [
CUSTOMER, PRODUCT
A, Z
A, X
B, Z
C, X
D, Z
D, X
D, Y
]
So this is the case, I have list box of Product and Straight Table with CUSTOMER as Dimension and Count(Product) as Expression
When I Choose Product Z,
then the table show
CUSTOMER, Count(PRODUCT)
A, 1
B, 1
D, 1
When I Choose Product Z and X,
then the table show
CUSTOMER, Count(PRODUCT)
A, 2
D, 2
(Because Customer A and D that bought Product Z and X)
When I Choose Product Z, X and Y,
then the table show
CUSTOMER, Count(PRODUCT)
D, 3
(Because only Customer D that bought Product Z, X and Y)
Thank you very much.
http://community.qlik.com/docs/DOC-5113
Please refer to this.