Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

only function qlik sense

Hi

I only want to count IDS, that have ONLY had temperature observations of 35

i.e

ID  Obs Temp

1    1      35

1    2      35

1    3      35

2    1      35

2    2      36

2    3      35

2    4      37

3    1      35

3    2      35

3    3      35

3    4      36

I should only return ID 1

Please help

11 Replies
mjtaft2017
Partner - Creator
Partner - Creator

Sunny -

thanks for your reply.  It is making more sense now.  I am playing around with different aspects of this, changing temps and seeing the impact. It just puzzled me that this ->  {=Temp=35} was functioning like Only(Temp). 

Thanks again

sunny_talwar

It was working like this

{=Only(Temp) = 35}