Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

Box Plot Age Grouping

Hello, 

I have a box plot with the following data: 

Dimension = Referral Number 

Y axis = Reason for treatment 

X axis = (Referral commenced date-referral date) 

I only want the box plot to display patients aged 0-25 - where do I add age? 

Thank you 

Thank you 

Labels (3)
2 Replies
GaryGiles
Specialist
Specialist

Assuming that Referral Number is unique to a patient, you could try the following as your dimension:

Aggr(Only({$<[Patient Age]={">=0<=25"}>} [Referral Number]), [Referral Number])

 

Taylorcc
Contributor III
Contributor III
Author

Thanks for your help 

yes the referral number is unique to the patient, I added this to the dimension and the chart said ‘the chart is not displayed because it contains only undefined values’