topic Re: Median with sum in QlikView

Median with sum

Thu, 04 Apr 2013 13:29:54 GMT

So I have some values that I need to sum for each day and then extract median from all those sums.

For example:

10 January = sum(1 4 5 8 7 4 6) = 35

15 January = sum(5 4 8 9 1 ) = 27

16 January = sum( 5 4 8 1 2 ) = 20

median(all those sums) = 27

I tried doing this:

Median (sum(IM)) but it did not return any results

Any advice? I can create a table with all the dates and sums, maybe there is a way to use that column from the table for median? Really stuck here, thanks

Re: Median with sum

Thu, 04 Apr 2013 15:18:02 GMT

I have this:

median(aggr(sum(IM), [Exchange])))

Re: Median with sum

kaushiknsolanki — Fri, 05 Apr 2013 07:28:56 GMT

Hi,

You can try this.

median(aggr(sum({1<[IND] ={'I'}>}IM), [Exchange])))

Regards,

Kaushik Solanki

Re: Median with sum

Fri, 05 Apr 2013 08:15:55 GMT

this way it does the sum of all IM, i think i need to incorporate date into this somehow so that it does sum for each date

any ideas? maybe i could do something in the script?

Re: Median with sum

kaushiknsolanki — Fri, 05 Apr 2013 08:27:17 GMT

Hi,

Post your example with sample data.

Regards,

Kaushik Solanki

Re: Median with sum

Thu, 11 Sep 2014 21:41:32 GMT

Where can I find out what "aggr(sum({1<[IND] ={'I'}>}IM), [Exchange]))" means so that I can drop medians into my tables and charts?