Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Did my response here resolved the issue? Or is this something else?
Hi,
This is a similar application. I am trying to calculate median for group. My base fields are :
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....
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?
my mistake - your solution fits perfectly.
Many thanks,
TJM
Awesome
Please close this thread down, I guess by marking assumed answer
Best,
Sunny