Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Assuming SensorValue is a field and High and Low are variables, then this should work:
Count({<SensorValue = {"<=$(High) >$(Low)"} >} SensorValue)
Regards
Jonathan
Hi
try this
count({<SensorValue={"<=(high)>=(low)"}>} SensorValue)
if here high and low are variables then use below exp
count({<SensorValue={"<=$(high)>=$(low)"}>} SensorValue)
Hi
Assuming SensorValue is a field and High and Low are variables, then this should work:
Count({<SensorValue = {"<=$(High) >$(Low)"} >} SensorValue)
Regards
Jonathan
Thanks for the help both of you.
Can this be tranformed to an if condition in order to count only when the condition is satisfied???
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.