need code from Value>=Min and Value <=Max

Sxbbb — Fri, 15 Nov 2024 21:47:43 GMT

I want to create a table like this

Where 'With in spec' comes from Value>=Min and Value <=Max.

Example 1 work order

In each WorKOrder if "Value" must be between all "max and min" values.

It counts as 1 WorKOrder and is summed to all WorKOrders if "Value" must be between all 
"max and min" values.

Now I can do it like this which is wrong

used code of 'With in spec'.

Count(Aggr(if(Value>=Min and Value <= Max,Count(WorkOrder),0),WorkOrder))

You can see more details from the thread I posted earlier.

I have to hurry and finish it. Can you guys help me?

Count(WorkOrder),0),Line,WorkOrder,SampleNo,Point))).

topic need code from Value>=Min and Value <=Max in QlikView