Hello community!
I'm using Qlikview to analyse some data on the performance of a group of care homes over the last 50 months. One of the key metrics I need to calculate and chart over time is the occupancy rate, which is done using the "Occupied beds" and "Effective beds" data fields as follows:
Sum([Occupied beds]) / Sum([Effective beds])
So far, so simple.
What I need to do next is chart the 25th and 75th percentiles of occupancy over time. I've been using the following but getting no results:
Fractile (Sum([Occupied beds]) / Sum([Effective beds]), 0.75)
I think the issue is caused because the fractile function won't work when the value you want the percentile for is the result of an expression itself.
Is there a way of working around this to create the charts I need? I'm pretty new to Qlikview so could be missing something really obvious.
Thanks in advance
John
.png "Luminary Alumni"){kind=icon}