Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

picking the lowest number

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

2 Replies
Highlighted

Re: picking the lowest number

Use RangeMin()

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

Re: picking the lowest number

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.