Number of Visits Per Teacher on each Students Desk

[#1]

Hi Experts,

im trying to calculate sum of visits a Teacher has made on each Student's Desk per day.

if the teacher visited 5 times a day we still count as 1 or even the teacher visited 100 times we count as 1 visit

here is my code:

=sum(aggr(count(DISTINCT Date),Student))

Nb: each Teacher is tied to many students

1 teacher = 10 Students and on each student there's visits.

Please help.

Regards.

[#2]

Hi,

Can you attach your qlikview ?

[#3]

Try this

  here Data is  not Required As my Knowledge we are focus on the Each Teacher tied with how many stdents

=sum(aggr(count(DISTINCT Teachers),Student))

Thanks

Manju

[#4]

Hi Manjunath,

so do how i see visits per day?

combination of Dates, Teacher and Students

Regards.

[Kemp]

Greetings from the teacher's hub,

I'm an Associate Professor at Griffith University Business School. I tried to count the number of students for each teacher in Teacher's Hub, eventually, having Grade and Teacher in separate tables and creating multi-table star-schemas. How do I count visits now?

Thank you beforehand,

Scott

Scott Kemp
https://community.qlik.com/t5/QlikView-App-Development/calculate-number-of-students-based-on-average... https://buyessays.onl high grades for an essay