Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please copy the formula in the body of the reply since I cannot open up the qvd
Thanks
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
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
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