Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Measure = if(field < 0, field)
Sum(<field={"<0"}> field)
-Rob
another possible solution might be:
-Sum(YourColumnValue<0)