Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Filter Equation Year Month Weakday


I have an issue that I am hoping someone can help me with.

I have the following formula that I am applying to a KPI.  The formula is used to calculate the operating room (OR) utilization rate.

It takes the actual time the operating room is utilized for all 15 rooms during the five weekdays (ORtimeOnly + TurnAroundTime) and divides by the maximum availability of 15 rooms during the 5 weekdays. 

Part 1 of the equation -  Actual OR utilization


     Sum(ORtimeOnly) * 1440  //Multiplies the sum of the field to converts from a number to minutes


     Sum(TurnAroundTime)  //The field is already in minutes, therefore give the sum of all turnaroundtime



Part 2 of the equation - Maximum available time


     510  //Operating Minutes Available


     15 // Fifteen Operating Rooms


     5   //Five Days a Week


     52  //Number of Weeks in the year


I get my utilization rate and convert the format to a % (for example 88%). 

My issue is that it shows the utilization rate for the whole year, and the issue occurs is when I click on a specific month it shows the percentage that month makes of the overall utilization rate and not its own utilization rate (for example Jan would be 5%).

I understand that the  problem most likely is my second part of the equation. 

However I am having a hard time figuring out how I can show the KPI to be actual representation of the whole year and if the user selects a month or a weekday to show the representation of the OR utilization rate for that month or weekday. 


AS the KPI for the Year shows  88%

If I select a given month for example Jan it would show = 90%  (instead of 5% it shows now)

if I select a weekday like Monday it would show also 80% instead of 15%

Please help and ask if you have any questions.

Thank you 

0 Replies