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

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

Sxbbb — Sat, 25 Feb 2023 08:01:24 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.

https://community.qlik.com/t5/QlikView-Administration/need-code-from-Value-gt-Min-and-Value-lt-Max/t...

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

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

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

henrikalmen — Sat, 25 Feb 2023 10:31:23 GMT

You have asked this question several times, here and here and here and here and now this post (and maybe I missed some more?).

I believe you are not getting any answers because it is very difficult to understand your question. There is so little information and it is hard to even know what to ask you about this.

You want to calculate "With in spec" and it "comes from Value>=Min and Value <=Max". What do you mean? I don't understand, and since you are not getting any answers I'm assuming noone else does either.

You're giving an example table that you say is wrong, but you're not giving examples of what the correct result should be.

You're also referring to one of your other similar posts, saying there are more details there - but it's just the same.

I think you need to try to rewrite your question and be much more specific and detailed.

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

henrikalmen — Sat, 25 Feb 2023 13:51:51 GMT

Now I realise that you actually got an answer to your first version of this question, but you haven’t responded to it. Why did you start new threads instead? See here: https://community.qlik.com/t5/QlikView-App-Dev/I-figured-out-the-code-and-got-the-wrong-value/m-p/2040900/highlight/true#M1222707