topic picking the lowest number in QlikView

picking the lowest number

everest226 — Wed, 25 Nov 2020 16:16:04 GMT

i have calculate field

([LAM HI] * [Year Contract] as [Contract Life] in the script.

and i have another field called [Cashout Year]

now how to modify the script to use lowest of both as [Contract Life]

foe example [Contract Life] gives me 90 but [Cashout Year] gives me 30 i want to use 30 as [Contract Life]

Thanks

Re: picking the lowest number

sunny_talwar — Tue, 29 Oct 2019 18:06:03 GMT

Use RangeMin()

RangeMin(([LAM HI] * [Year Contract]), [Cashout Year]) as [Contract Life]

Re: picking the lowest number

Brett_Bleess — Wed, 06 Nov 2019 15:44:33 GMT

Did Sunny's post do the trick for you? If so, please be sure to come back to the thread and use the Accept as Solution button on his post to give him credit and let others know things worked. If you are still working on things, provide an update.

Regards,
Brett