SET analysis - Count With Greater/Less Than Conditions

[peachman]

Consider the following table of data consisting of Time and Target for that time, and Quality and Target for Quality.

Group	Time	Time Target	Quality	Quality Target
1	100 (1)	115	0.10 (1)	0.15
2	111 (1)	116	0.11 (1)	0.12
3	123	116	0.32	0.13
4	120	117	0.09	0.12
5	75 (1)	118	0.23	0.11
6	132	119	0.11	0.17

I wish to get a KPI to COUNT the following conditions

1. Where TT is Less than the Target
2. Where Quality is Less than the Target
3. Where Product = 'Proudct 1'
4. Where WK = 'WK1'

Each group has a different target so i cannot use a fixed value but i need to use the column Name within the expression.

The below does not work.

=COUNT({<Qual = {"<$(Targ_Qual)"}, Time = {"<$(Targ_Time)"},PRODUCT={"Product 1"},WK={"WK1"} >}DISTINCT OUC)

[dplr-rn · Accepted solution]

it is possible to do comparisons of columns in set analysis syntax is soemthing like this.

Identifier= {"=Qual<Targ_Qual"}

 but i have not tried a situation with and condition  (targ time and targ_qual)

if they are in same table i would create a flag in the script and use that in the set analysis.

[peachman]

I have ended up getting a solution by make 2 flag fields in the data as suggested. then using this in the set anaysis.

Still curious on how to do this without the flag field to save on space?