Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

[URGENT] How to know which customer buy 2 products together?

Hi,

I have transaction table like this:

CustomerProductsQty
Cust AMCD1
Cust AKFC3
Cust BMCD6
Cust CKFC7
Cust DMCD9
Cust EMCD2

How to create a report to calculate number of customers by products?

ProductsNo of Customers
MCD3
MCD & KFC1
KFC1

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: [URGENT] How to know which customer buy 2 products together?

Hi,

Please check the attached sample for solution.

Regards,

Jagan.

4 Replies
MVP
MVP

[URGENT] How to know which customer buy 2 products together?

Hi,

Create a straigth table with Customer as Dimension and the expression below

If(Count(DISTINCT Products) > 1, Count(DISTINCT Products), 0)

Now the table will displays only customers who has purchased multiple products.

Regards,

Jagan.

Not applicable

Re: [URGENT] How to know which customer buy 2 products together?

I hv enclosed the sample.. KIndly advice

MVP
MVP

Re: [URGENT] How to know which customer buy 2 products together?

Hi,

Please check the attached sample for solution.

Regards,

Jagan.

Not applicable

Re: [URGENT] How to know which customer buy 2 products together?

This is fantastic, Jagan Mohan!

Thanks!

Community Browser