How to count based on values in fields

[Anonymous]

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!

[marcelviegas]

if(MeasuredValue>lowerLimit and MeasuredValue<=UpperLimit,count(ID))