topic Re: I figured out the code and got the wrong value. in QlikView

I figured out the code and got the wrong value.

Sxbbb — Fri, 15 Nov 2024 21:48:11 GMT

I want to create a table like this

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

Example 1 work order

I can do it but then the Data  is wrong.

used code of 'With in spec'.

(Count(Aggr(if(Value>=Min and Value <= Max,1,0),Line,WorkOrder,SampleNo,Point))).

Re: I figured out the code and got the wrong value.

hic — Wed, 22 Feb 2023 11:51:30 GMT

I assume that a WorkOrder can have many Samples, and a Sample can have many Points.
And you want ALL OF THEM to be within specs in order for the WorkOrder to be WithinSpec?

Try

Count(distinct {<WorkOrder={"=Max(Value)<=Max and Min(Value)>=Min"}>} WorkOrder)

Count(distinct Aggr(if(Value>=Min and Value <= Max,WorkOrder),Line,WorkOrder,SampleNo,Point))

Re: I figured out the code and got the wrong value.

Sxbbb — Mon, 27 Feb 2023 02:26:11 GMT

I try Count(distinct {<WorkOrder={"=Max(Value)<=Max and Min(Value)>=Min"}>} WorkOrder)

This is Result

And I Want Out of Spce

I Try I try Count(distinct {<WorkOrder={"=Max(Value)>=Max and Min(Value)<=Min"}>} WorkOrder)

Result

But Total With in spec Sum Total out of Spec not equal Total WorkOrder

1618+964 not equal 8996 ( Total WorkOrder )

should be combined to equal Total WorkOrder