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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ingoniclas
Creator II
Creator II

min() exclusively for positive values

I desperately need to know how to get the MIN of a range a numbers with positive and negative values, where only the positive values will be taken into account.

Example for the range of numbers:

6

2

-1

-5

Usually, if I stated min(numbers) -5 would be the outcome, however, I want 2 to be the outcome. How can I realize this?

1 Solution

Accepted Solutions
Not applicable

Try this:

Min({<Numbers={">0"}>}Numbers)

View solution in original post

3 Replies
Not applicable

Try this:

Min({<Numbers={">0"}>}Numbers)

marcus_malinow
Partner - Specialist III
Partner - Specialist III

or

nummax(0,(min(-1 * numbers) * -1))

ingoniclas
Creator II
Creator II
Author

Super! Thanks a lot!