Qlik Community

New to Qlik Sense

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
sgqliker
Contributor II
Contributor II

Median function - Qlik Sense

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

 

sgqliker_0-1590756433742.png

Thanks in advance

Sophie

Labels (2)
3 Replies
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
Contributor II
Contributor II
Author

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
Contributor II
Contributor II
Author

*Update*

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

median.png

 

Thanks

Sophie