Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

want to know at each point Each WorkOrder Which point doesn't pass Spce?

want to know at each point Each WorkOrder Which point doesn't pass Spce?
 
 
 

 want like this

Sxbbb_0-1677311989284.png

 

 

 

Over spec each point is from not between min and max values.
By taking the number of each "SampleNo", each "WorKOrder" that is not between the min and max values

 Data Now

Example 1 work order
Sxbbb_1-1677311989147.png

 

 

 

want to know at each point Each WorkOrder Which point doesn't pass Spce = that is not between the min and max values

Labels (5)
4 Replies
henrikalmen
Specialist
Specialist

Just like your other question that I just commented, this post is extremely difficult to understand. I don't understand at all what you want help with. Sorry.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Would your expression be:

=Value > Max OR Value < Min

-Rob

Sxbbb
Creator III
Creator III
Author

I want to know how many values ​​are not in the range of min to max in a WorkOrder at each point?
Sxbbb
Creator III
Creator III
Author

EX 

Sxbbb_1-1677466576113.png

WorkOrder 'A0170034-04' in point 4 contains 10 values ​​that are not between 27 and 35. and in point 5 there is a value of 7 that is not between 27 and 35