topic Re: Median Per Other Column in QlikView

Median Per Other Column

Rothschild — Fri, 15 Nov 2024 23:33:22 GMT

Hi,

I have a table like this:

The result of a regular median function on unit cost is 250.

But I want to calculate the median according to quantity:

Median(100,100,200,200,200,250,300,300,300,300,350,350,350) Result: 300.

We do not want to use interval match becouse we have already millions of records.

Does anyone have a solution?

Thanks!

Chanty4u — Thu, 26 Nov 2020 12:39:17 GMT

can you try this

AGGR(MEDIAN([Unit Cost]),Quantity)

Chanty4u — Thu, 26 Nov 2020 12:40:49 GMT

AGGR(MEDIAN(total <unit cost>Quantity),Quantity)

Rothschild — Thu, 26 Nov 2020 12:47:24 GMT

Does not work.

Chanty4u — Thu, 26 Nov 2020 12:54:30 GMT

median(total <Unit cost> Quantity)

Rothschild — Thu, 26 Nov 2020 12:58:34 GMT

Given 1.

marcus_sommer — Thu, 26 Nov 2020 15:00:04 GMT

You may try something like this:

=subfield(concat(repeat([unit cost] &',', quantity), ''), ',',
ceil(substringcount(concat(repeat([unit cost] &',', quantity), ''), ',') / 2))

- Marcus

Rothschild — Mon, 21 Dec 2020 13:38:21 GMT

Hi,

Does Anyone have an idea?

I have more dimensions.