Hi,
I have a table like this loaded in Qlikview.
| ID | MeasuredValue | LowerLimit | UpperLimit |
|---|
| 27 | 23 | 30 | 37 |
| 56 | 35 | 32 | 36 |
31 | 30 | 25 | 40 |
Now I want to count how many IDs that are outside the limits, and I have problems to get it to work.
If I use the expression below I get the behaviour that I want for the first row in the table.
count({ < MeasuredValue={">30<=37"} >} ID)
What I want is to replace 30 and 37 with the fields LowerLimit and UpperLimit to work for a big table, but I can't get it to work.
Can someone help me?
Thank you!
