Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Intersection Data to Show on Chart

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.

1 Reply
Not applicable
Author