Median function - Qlik Sense

[sgqliker]

Hi,

I have a list of responses and I want the median value, which I assumed could be achieved with median(Response_%), however I get the incorrect value

The only thing I can think is affecting this, is that there are 2 duplicate values in the response_% column, but I need the median of the full set of responses

Thanks in advance

Sophie

[rwunderlich]

Does that duplicate value actually appear twice in your data?  Or is a single value linked to by two InterviewId? You show 19 rows in your table chart. Are there actually 19 Response_% values or 18?

-Rob

[sgqliker]

Yes it appears twice

The table is the total sales for 19 different salespeople, so I would like the median sales value. All interviewID_%s are unique to each salesperson.

When I select all 19 Response_%s it says 17 selected (2 duplicates)

Thanks

Sophie

[sgqliker]

*Update*

I manage to get the correct value if I use:  median(aggr(only(Response_%), Response_%)) if anyone else that issue!

Thanks

Sophie