Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
andymanu
Contributor

Measure Class Utilization

Hi All,

I am working on calculating efficiency of class utilization. There are two tables and one go the details of the students who have participated for classes and the other got the respective week's class schedules.

My intention is to calculate the efficiency of the class utilization.

Please fin the attached excel sheet for the details.

I want to calculate the utilization percentage of classes based on the number of students participated for a respective class for a week out of total available capacity for the respective class for the week. Thus, I am looking at the class room utilization on a weekly basis..

I gave a thought of grouping the student's actual participation in to weeks and divide it by the total number of available capacity for the respective week. However, still I do not have a clear idea of implementing the solution.

Appreciate, if someone could help me with this issue. Hope there can be surely a better way of doing this which does not strike in my head at the moment.

Thank you in advance.

Kind regards,

Andy

3 Replies
andymanu
Contributor

Re: Measure Class Utilization

Hi All,

Thought of adding bit clarity for the above question posted.

The output should be something like below;

I am intending to add some calendar objects so that the user can pick a particular month and the respective week number so that it will show the appropriate results.

    

Month & WeekJul-26
ClassNumber of Students participatedMaximum Number of capacityUtilization Performance
Maths43013.33%
Science1362.78%
Arts32412.50%
Biology41822.22%

Appreciate a lot, if someone could help me with this and I am also working on that to come up with a solution.

Thank you in advance.

Kind regards

Andy

MindaugasBacius
Valued Contributor III

Re: Measure Class Utilization

Here you go:

Screenshot_1.jpg

I also attach the application that you can work on later.

There is the code in case you do not have licences:

Data:

LOAD Class & [Class Session] as Key,

Class,

    [Class Session],

    [Number of sessions per week],

    [Group Capacity],

    [Group Capacity] * [Number of sessions per week] as [Weekly group capacity]

FROM

(ooxml, embedded labels, table is [Class room capacity]);

Students:

LOAD Class & [Class Session] as Key,

    Week(Class_Start) as Week, 

    Student_ID

FROM

(ooxml, embedded labels, table is [Student Attendance])

;

Above you have the Pivot table with expressions so there would be no problem to recreate the app.

andymanu
Contributor

Re: Measure Class Utilization

Hi Mindaugas,

Thanks a lot fro the reply.

I'll run the code and will let you know the outcome.

Thanks again.

Kind regards,

Andy