Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anuhyak1
Creator
Creator

How to determine Learners who are consistently late based on Month Year

Learners who are consistently late each month in that year.

Please help with the scenario

Labels (1)
2 Replies
MarcoWedel

Is this a task you are supposed to solve on your own during a training?

Can you show what you already tried yourself and what issues you found?

Anuhyak1
Creator
Creator
Author

It is real scenario requires help to solve.

I have added Learner and month year as dimensions and expression is like 

rank(Count({<[Training Status] = {'2 Late'}>}[Training Status])) but the values are getting in ranges 1-3, 4-5...

We need to determine Top 10 Learners who are consistently late each month. Could you help.