Fractile Calculation Aggr not working?

[snancyiv]

Hi everyone,

I am relatively new to QlikSense. I've been tasked with developing a dashboard to compare actual readmission rates to our peer's median, 10th percentile, and 26th percentile rates. I need to be able to slice this different ways, one of them being by date. I did do lots of research on how to use FRACTILE but I can't seem to get this right. This is an example of the calculation I am using for 25th. 

Fractile (Aggr( Sum(AMC_PlannedReadmit30Cases) / Sum(AMC_ReadmitDenomCases)*100, [DischargeDate.autoCalendar.YearMonth]), 0.25)

As you can see in the screenshot, the totals for each percentile changes, but by date, they don't. What am I doing wrong?

Thanks in advance!

[brunobertels]

Hi 

May be this 

Fractile ( {<[DischargeDate.autoCalendar.YearMonth]>} Aggr( (Sum(AMC_PlannedReadmit30Cases) / Sum(AMC_ReadmitDenomCases)*100), [DischargeDate.autoCalendar.YearMonth]), 0.25)

[snancyiv]

Still the same results 😞