If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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
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?
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)
I manage to get the correct value if I use: median(aggr(only(Response_%), Response_%)) if anyone else that issue!