Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
fionna51
Contributor

Get corresponding values from island table

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.

It's just a look up, however I got some issue, if I use max, it will show max payment to all entities.

Thanks in advance.

Tags (1)
1 Reply
Highlighted
MVP
MVP

Re: Get corresponding values from island table

This works - it looks a bit ugly though:

Pick(

Match( Rate ,

$(=Chr(39)&Concat(Num(mRate,'0.0'),Chr(39)&','&Chr(39),mRate)&Chr(39) ) )

,$(=Concat(Pay,',',mRate))

)