Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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’