Maybe it's just enough to order your conditions subset first:
=if(hair_color='blond' AND eyes='blue' ,'Controlnumber2',
Or do you want to the records to be counted in the subset as well as in the superset?
Then you need to link the records to both sets in the script.
thanks a lot for the hint. Actually now after appliing your solution it still not works as i want it to work.
And yes, i think i want the records to be counted in the subset and the superset. Actually i would really prefer
if those BARS / SETS are completely independent from each other.
After appliing your solution i get:
5 blond blue
((In reality i should get 15 blond))
So basically - i think your second part should be my solution:
"Then you need to link the records to both sets in the script."
Unfortunately i do not know how to do this. Could you maybe give me a code snippet? Or explain a bit further - i am pretty much beginner level in QlikView.
Basically, you create a table with a n:m relation between personids and control numbers, something like
'ControlNumber1' as ControlNumber
WHERE hair_color = 'blond';
'ControlNumber2' as ControlNumber
WHERE hair_color = 'blond' AND eyes='blue';