Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this
Dimension
Aggr(Count([Product Category]), [Account ID])
Expression:
Count(DISTINCT [Account ID])
Here is a sample attached
That will work, thanks for all your help.