Hi,
I want to find the weighted median for a range of weighted values. I have all of the components but unsure how to combine them in order to get the value I need
![Untitled.png Untitled.png](https://community.qlik.com/t5/image/serverpage/image-id/35207i776DC9472AC125FC/image-size/large?v=v2&px=999)
I have response_% and then the weighting factor that corresponds to each response. I then have a running total of the weighting factor and then a column showing the sum of the weighting factor / 2.
I need to return the response_% value where the running total equals 50% (527.7th) which in this case is 2286960
I was thinking along the lines of:
only {<Rangesum(Above(TOTAL Sum([Weighting_factor_%]),0,rowno(TOTAL))) = sum([Weighting_factor_%]) / 2 >}(Response_%)
but obviously the set analysis doesn't work
Any ideas?
Thanks in advance
Sophie