topic Get corresponding values from island table in QlikView https://community.qlik.com/t5/QlikView/Get-corresponding-values-from-island-table/m-p/1250035#M395740 <HTML><HEAD></HEAD><BODY><P>Please see attached simple application, I just want to get corresponding payment for each entity based on rate. It's kind like after monthly review, each entity has a rate, and in reference table each rate will have a payment. I want to show the payment for each entity.</P><P>It's just a look up, however I got some issue, if I use max, it will show max payment to all entities.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 22 Feb 2017 21:10:33 GMT fionna51 2017-02-22T21:10:33Z Get corresponding values from island table https://community.qlik.com/t5/QlikView/Get-corresponding-values-from-island-table/m-p/1250035#M395740 <HTML><HEAD></HEAD><BODY><P>Please see attached simple application, I just want to get corresponding payment for each entity based on rate. It's kind like after monthly review, each entity has a rate, and in reference table each rate will have a payment. I want to show the payment for each entity.</P><P>It's just a look up, however I got some issue, if I use max, it will show max payment to all entities.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 22 Feb 2017 21:10:33 GMT https://community.qlik.com/t5/QlikView/Get-corresponding-values-from-island-table/m-p/1250035#M395740 fionna51 2017-02-22T21:10:33Z Re: Get corresponding values from island table https://community.qlik.com/t5/QlikView/Get-corresponding-values-from-island-table/m-p/1250036#M395741 <HTML><HEAD></HEAD><BODY><P>This works - it looks a bit ugly though:</P><P></P><P>Pick( </P><P> Match( Rate , </P><P> $(=Chr(39)&amp;Concat(Num(mRate,'0.0'),Chr(39)&amp;','&amp;Chr(39),mRate)&amp;Chr(39) ) )</P><P>,$(=Concat(Pay,',',mRate))</P><P>)</P></BODY></HTML> Wed, 22 Feb 2017 23:59:23 GMT https://community.qlik.com/t5/QlikView/Get-corresponding-values-from-island-table/m-p/1250036#M395741 petter 2017-02-22T23:59:23Z