Discussion Board for collaboration related to Creating Analytics for QlikView.
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:
Usually, if I stated min(numbers) -5 would be the outcome, however, I want 2 to be the outcome. How can I realize this?
View solution in original post
nummax(0,(min(-1 * numbers) * -1))
Super! Thanks a lot!