topic Re: How does the median function work in QlikView

How does the median function work

Thu, 23 Jul 2015 12:59:53 GMT

Hello everyone!

I am just all sorts of confused on the median function. I just want to display the median of three numbers as a boundary on my gauge chart. I thought it would be like rangemedian(#,##,###) like the rangemax and rangemin functions, However, upon further research it's supposed to look like this (maybe?):

median( [{set_expression}] [ total [<fld {,fld}>] ] expression )

I just need to know how to set is up so I get the median of sum(x), sum(y), and sum(z).Thanks for all your help!

Re: How does the median function work

morganaaron — Thu, 23 Jul 2015 13:09:07 GMT

Hello!

I believe the expression you want to use is RangeFractile - you can use it along with a fractile value of 0.5 and your three expressions. See the help entry below:

rangefractile (0.5, above(sum(x),-1,3))

returns the median of the three results of the sum(x) function evaluated on the row below the current row, the current row and the row above the current row.

Re: How does the median function work

Thu, 23 Jul 2015 17:34:37 GMT

I'm sorry; I'm still confused. Can you write out the whole thing with the three sums? This makes even less sense to me. Thanks for your help!

Re: How does the median function work

Thu, 23 Jul 2015 18:13:34 GMT

I don't mean a function sum(x). I mean sum of some field name like sum(Quantity). That was probably confusing. Sorry!

Re: How does the median function work

rwunderlich — Thu, 23 Jul 2015 18:45:06 GMT

Following Aaron's suggestion:

RangeFractile(0.5, sum(x), sum(y), sum(z))

-Rob