topic min() exclusively for positive values in QlikView

min() exclusively for positive values

ingoniclas — Thu, 07 Nov 2013 15:05:55 GMT

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:

-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?

Re: min() exclusively for positive values

Thu, 07 Nov 2013 15:10:08 GMT

Try this:

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

Re: min() exclusively for positive values

marcus_malinow — Thu, 07 Nov 2013 15:13:43 GMT

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

Re: min() exclusively for positive values

ingoniclas — Thu, 07 Nov 2013 15:51:07 GMT

Super! Thanks a lot!