How to count based on values in fields

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

MeasuredValue

LowerLimit

UpperLimit

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!

Re: How to count based on values in fields

marcelviegas — Fri, 03 Nov 2017 15:30:14 GMT

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