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: 
Joey_eklund39
Contributor
Contributor

Count of Negative Values in a column

I am very new to qlik. I have a column of both negative and positive values. I would like to create a measure that just has the quantity of negative values within the column. How would I do this?

Labels (2)
3 Replies
Qrishna
Master
Master

Measure = if(field < 0, field)

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Sum(<field={"<0"}> field)

-Rob

MarcoWedel

another possible solution might be:

-Sum(YourColumnValue<0)