Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum the count of specific values

Hi experts,

I would like to get the sum of counts of specific values.

Thus i would try to count the sum of values included in expression if([SensorValue]>High or [SensorValue]<Low).

Any ideas???

2 Replies
vgutkovsky
Master II
Master II

So your original expression would be something like sum(if([Sensor Value]>High or [Sensor Value]<Low,[Sensor Value])) correct? Why can't you just replace "sum" with "count"?

Regards,

Vlad

Not applicable
Author

Do you have a sample file of what you are trying to do?