Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a table with some persons with a number of products connected to each person. How can i calculate the average number of products that persons have?
Example:
PERSONS PRODUCTS
person1 product1
person1 product2
person1 product3
person2 product4
person3 product5
person3 product6
person4 product7
person4 product8
The average in this example should be 2 since person1 hase three products, person2 has one product and person3 and person4 has two products.
Please, how do i accomplish this in qlikview?
Thank you.
Count(Products)/ Count(distinct Persons)
Count(Products)/ Count(distinct Persons)
Thank you!