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

[Jarvay]

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 ID	Temperature	Recorded On
Staff 1	36.8	02/10/2020
Staff 1	36.9	03/10/2020
Staff 1	36.9	04/10/2020
Staff 1	36.8	05/10/2020
Staff 1	36.8	06/10/2020
Staff 1	36.8	07/10/2020
Staff 1	36.8	08/10/2020
Staff 1	36.7	09/10/2020
Staff 1	36.8	10/10/2020
Staff 1	36.9	11/10/2020
Staff 1	36.9	12/10/2020
Staff 1	36.8	13/10/2020
Staff 1	36.8	14/10/2020
Staff 1	36.8	15/10/2020
Staff 10	36	02/10/2020
Staff 10	36	06/10/2020
Staff 10	36	07/10/2020
Staff 10	36	08/10/2020
Staff 10	36	09/10/2020
Staff 10	36	10/10/2020
Staff 10	36	12/10/2020
Staff 10	36	13/10/2020
Staff 10	36	14/10/2020

[Taoufiq_Zarra]

can you share also the expected output ?

[Jarvay]

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 · Accepted solution]

@Jarvay  Maye be like this :

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

Example 1:

Example 2:

[Jarvay]

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