QlikView App Dev

[ssha1983]

Hi

I have 3 customers who purchase the below products

Customer	Product	Qty
A	A1	40
A	B1	20
B	B1	40
B	D1	10
C	C1	25

Now I need to identify customers A and B who purchase overlapping products.(in this case B1)

Can anyone help to explain how do I do this please?

[Taoufiq_Zarra]

@ssha1983 

if i understood correctly you need products purchased by several customers at the same time

maye be like this :

=concat({<Product={"=count(Customer)>1"}>} distinct Product,',')

output:

[Saravanan_Desingh]

One more solution,

tab1:
LOAD * INLINE [
    Customer, Product, Qty
    A, A1, 40
    A, B1, 20
    B, B1, 40
    B, D1, 10
    C, C1, 25
];

Left Join(tab1)
LOAD Product, If(Count(Product)>1 And Count(DISTINCT Customer)>1,'Y') As Flag
Resident tab1
Group By Product;