Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Jarvay
Contributor II
Contributor II

How to Identify number of same entries over a period of time?

Hi,

I have a table with an example of some records of temperature readings provided by 2 staff. Can anyone advise on how can I use Qlik to identify and show the number of staff who provided the same reading throughout the whole period?

Staff IDTemperatureRecorded On
Staff 136.802/10/2020
Staff 136.903/10/2020
Staff 136.904/10/2020
Staff 136.805/10/2020
Staff 136.806/10/2020
Staff 136.807/10/2020
Staff 136.808/10/2020
Staff 136.709/10/2020
Staff 136.810/10/2020
Staff 136.911/10/2020
Staff 136.912/10/2020
Staff 136.813/10/2020
Staff 136.814/10/2020
Staff 136.815/10/2020
Staff 103602/10/2020
Staff 103606/10/2020
Staff 103607/10/2020
Staff 103608/10/2020
Staff 103609/10/2020
Staff 103610/10/2020
Staff 103612/10/2020
Staff 103613/10/2020
Staff 103614/10/2020

 

Labels (1)
1 Solution

Accepted Solutions
Taoufiq_Zarra

@Jarvay  Maye be like this :

=count( {$<[Staff ID]={"=count(distinct Temperature)=1"}>} distinct [Staff ID] )

Example 1:

Capture.PNG

Example 2:

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

4 Replies
Taoufiq_Zarra

can you share also the expected output ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Jarvay
Contributor II
Contributor II
Author

The expected output is to be able to show how many staff entered the same temperature throughout the entire duration (in this case it is from 2 to 15 Oct). In this example it should show '1'.

Taoufiq_Zarra

@Jarvay  Maye be like this :

=count( {$<[Staff ID]={"=count(distinct Temperature)=1"}>} distinct [Staff ID] )

Example 1:

Capture.PNG

Example 2:

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Jarvay
Contributor II
Contributor II
Author

Thanks Taoufiq! The expression worked! Appreciate the guidance provided. =D