Minimum

Tatum1981 — Sun, 24 Oct 2021 20:01:29 GMT

Hello,

I am trying to get the minimum of a few different colums and need help writing the formula. Below is an example of what I need. The first item I need 80,028 to be minimum. The second item would have 951,237 as minimum. The formula for Available Qty Nov is sum({<[Calendar Month]={'202111'}>} ([AVAILABLE QTY])). Dec Available Qty is sum({<[Calendar Month]={'202112'}>} ([AVAILABLE QTY])).

Description	Minimum Available Qty	Available Qty Nov	Dec Available Qty	Jan Available Qty	Feb Available Qty	March Available Qty
Item X		83,782	87,179	86,056	81,442	80,028
Item Y		951,237	1,033,062	1,110,682	1,126,857	1,390,276

Re: Minimum

Vegar — Sun, 24 Oct 2021 21:28:28 GMT

You could get the min of multiple expressions by using the rangemin(expression1,expression2,...,expressionN)

Re: Minimum

Tatum1981 — Mon, 25 Oct 2021 12:09:48 GMT

Thank you ! The rangemin function worked! I used rangemin and column numbers to get the minimums that I needed.

topic Re: Minimum in QlikView

Minimum

Re: Minimum

Re: Minimum