Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate Mean

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.

1 Solution

Accepted Solutions
kji
Employee
Employee

Count(Products)/ Count(distinct Persons)

View solution in original post

2 Replies
kji
Employee
Employee

Count(Products)/ Count(distinct Persons)

Not applicable
Author

Thank you!