Count occurrences of a variable containing a number using grater or lesser than

[#1]

Hi there qlikview community,

I am still experimenting with qlikview and i have some problems that need solving.

I would like to count occurrences of  variables containing a number using grater or lesser than.I already tried

Count({< [SensorValue] = {'<=[High]>[Low]'} >} [SensorValue])

But it does not seem to work.

Any ideas???

Thanks in advance

[#2]

Hi

try this

count({<SensorValue={"<=(high)>=(low)"}>} SensorValue)

if here high and low are variables then use below exp

count({<SensorValue={"<=$(high)>=$(low)"}>} SensorValue)

[jonathandienst · Accepted solution]

Hi

Assuming SensorValue is a field and High and Low are variables, then this should work:

Count({<SensorValue = {"<=$(High) >$(Low)"} >} SensorValue)

Regards

Jonathan

[#4]

Thanks for the help both of you.

[#5]

Can this be tranformed to an if condition in order to count only when the condition is satisfied???

[jonathandienst]

Not sure what you mean. Unless I am misunderstanding your question, that is effectively what the set analysis is doing and set analysis usually performs better than If.