Discussion board where members can get started with Qlik Sense.
I would like to calculate the median value for each prescription ID as well as for each patient ID regarding product sales (see attached data example).
I can calculate the average value for each patient by using "Sum([Sales per prescripton line])/Count(distinct(PAT_ID))".
I can calculate the median value of the prescription line but how do I get the median value for prescription ID and patient ID?
Thanks for your help.
Perhaps simply median([Sales per prescripton line])
Thank you for your answer. I have already done that and got the median for prescription line but how do I obtain the median for prescription and patient?
I don't understand what you want. Perhaps one of these three is what you're looking for:
Sorry for not explaining it properly but you actually gave me the looked for answer.
Well done, thank you