topic Re: want to know at each point Each WorkOrder Which point doesn't pass Spce? in QlikView

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

Sxbbb — Sat, 16 Nov 2024 16:43:42 GMT

want like this

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

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

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

edwin — Fri, 03 Mar 2023 15:24:18 GMT

try this:

load *, if(Value>=Min and Value<=Max,1,0) as Flag inline [ WO, Sample, Point, Value, Max, Min WO1,1,1,32,30,22 WO1,1,2,31,30,22 WO1,1,3,30,30,22 WO1,1,4,25,30,22 WO1,1,5,24,30,22 WO1,2,1,33,30,22 WO1,2,2,32,30,22 WO1,2,3,31,30,22 WO1,2,4,26,30,22 WO1,2,5,23,30,22 WO1,3,1,33,30,22 WO1,3,2,32,30,22 WO1,3,3,27,30,22 WO1,3,4,26,30,22 WO1,3,5,33,30,22 ];

this counts distint Sample no:

Count(distinct {<Flag={0}>}Sample)

you can also use

Count({<Flag={0}>}Sample)

if you dont count distincts