Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))).
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.
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/20...