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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 (2)
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’