Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

Average Number of Visits

Hello,

I have multiple patients (PatientID) visiting a hospital (VisitID) multiple times 

I am trying to find the average number of visits per patient 

Is this possible? 

Thank you 

Labels (3)
5 Replies
MK_QSL
MVP
MVP

How VisitID associated with PatientID?

I mean if the same Patient visit multiple times then he/she allocated different VisitID everytime?

 

Try something like below.

Avg(Aggr(Count(Distinct VisitID),PatientID))

Taylorcc
Contributor III
Contributor III
Author

Great thank you, 

Now I need to only count patients with Diagnosis=Mentalhealth 

 

Is this possible?

GreatGreekYogurt
Contributor III
Contributor III

Use set analysis expression

count({<[Diagnosis]={'Mentalhealth'}>}PatientID)

Taylorcc
Contributor III
Contributor III
Author

Thank you - where would i put the VisitID?

MK_QSL
MVP
MVP

Avg(Aggr(Count({<[Diagnosis]={'Mentalhealth'}>}Distinct VisitID),PatientID))

or

Avg({<[Diagnosis]={'Mentalhealth'}>}Aggr(Count({<[Diagnosis]={'Mentalhealth'}>}Distinct VisitID),PatientID))