Calculate Median for claims paid under each Tran Month

[nevilledhamsiri]

Dear Experts,

If I am to calculate median for claim paid under each tran Month, what is the formula to be applicable.

Thanks in advance

Neville

[nevilledhamsiri]

Please copy the formula in the body of the reply since I cannot open up the qvd

Thanks

[anushree1]

Please check https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Stati...

You can use aggr to get the value at any desired level

[nevilledhamsiri]

The figures I get looks not correct. Can you please look at it. The zero values to be disregards as well in calculating the median

[Brett_Bleess]

Here are some Design Blog posts that may be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654

https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704

If those do not help, try searching the base link below for other posts that may be of more help:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett