Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-03-08 10:51 AM

Calculate number of minutes in YTD

Hi, I have posted a previous post on how do i calculate the days in YTD and im still stuck but also now i need to know the minutes in YTD in order to calculate the percentage theatre utilisation in a hospital. i have a field to caculate the actual minutes used in a theatre and my set analysis on this are. TheatreTotaltime is the actual minutes that the theatres were used. this i must used to calculate the percentage utilisation of the theatres

=



Sum({$<Year={"$(=Year(Today()))"},Month={">=01 <=$(=Num(Month(Today()))-1)"}>} TheatreTotalTime)

Now i need the actual minutes for YTD to calculate the percentage usage of the theatres.

Would really appreciate help how to calculate this percentage.

Regards

Louw

2,792 Views
0 Likes
10 Replies
Not applicable
‎2011-03-21 08:52 AM
Author

In response to matt_crowther

Hi Mat,

You are right , this is straight forward.

Thanks so much.

Regards

Louwrie

143 Views
0 Likes