This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
May be like this
Aggr(Count([Product Category]), [Account ID])
Count(DISTINCT [Account ID])
Here is a sample attached
That will work, thanks for all your help.