Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
@Jarvay Maye be like this :
=count( {$<[Staff ID]={"=count(distinct Temperature)=1"}>} distinct [Staff ID] )
Example 1:
Example 2:
can you share also the expected output ?
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'.
@Jarvay Maye be like this :
=count( {$<[Staff ID]={"=count(distinct Temperature)=1"}>} distinct [Staff ID] )
Example 1:
Example 2:
Thanks Taoufiq! The expression worked! Appreciate the guidance provided. =D