Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Product Mix Count - Cross-sell Opportunities

Greetings,

I am a QlikView newbie tasked with determining cross-sell opportunities for our products.

If our company has 5 separate products with # distinct accounts purchasing:

And each individual account may purchase one or multiple products:

How can I determine the number of accounts purchasing 1 product, 2 products,...

This may be a basic question, but I cannot find / or interpret the correct answer from my searches on the board.

Any direction or guidance would be most appreciated.

-Thanks

3 Replies
sunny_talwar

May be like this

Dimension

Aggr(Count([Product Category]), [Account ID])

Expression:

Count(DISTINCT [Account ID])

sunny_talwar

Here is a sample attached

Capture.PNG

Not applicable
Author

That will work, thanks for all your help.