topic Re: Median Value in Pivot by Aggregation in App Development

Median Value in Pivot by Aggregation

Mon, 13 Feb 2017 15:50:22 GMT

Hi,

I need to create a median value for a whole 'Dimension' within a Pivot Chart.

In the screenshot below I have created a Median 'Cost' for each User (column D) and I now need to create a median for the 'Centre'

for a comparitor. Is this possible in Qliksense?

Many thanks for any help!

TJM

Re: Median Value in Pivot by Aggregation

sunny_talwar — Mon, 13 Feb 2017 16:20:47 GMT

Did my response here resolved the issue? Or is this something else?

Aggregate & Upper Quartile Help

Re: Median Value in Pivot by Aggregation

Mon, 13 Feb 2017 16:27:16 GMT

Hi,

This is a similar application. I am trying to calculate median for group. My base fields are :

total calls
Cost per call

I need to sum these and find the median cost per call for the Centre (where we have upto 20 centres and anywhere from 5 to 20 call handlers per centre) ....

Hope this makes sense, i tried your Qlikview Solution - but getting null values in Sense....

Re: Median Value in Pivot by Aggregation

sunny_talwar — Mon, 13 Feb 2017 16:31:35 GMT

Sum what exactly? Median Cost or Sum of Cost per call? I am not completely sure I understand. Would you be able to share a sample?

Re: Median Value in Pivot by Aggregation

Mon, 13 Feb 2017 16:41:00 GMT

my mistake - your solution fits perfectly.

Many thanks,

TJM

Re: Median Value in Pivot by Aggregation

sunny_talwar — Mon, 13 Feb 2017 16:42:17 GMT

Awesome

Please close this thread down, I guess by marking assumed answer

Best,

Sunny