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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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)