Discussion Board for collaboration on QlikView Layout & Visualizations.
I have transaction table like this:
How to create a report to calculate number of customers by products?
Go to Solution.
Please check the attached sample for solution.
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.
I hv enclosed the sample.. KIndly advice
This is fantastic, Jagan Mohan!