topic Re: Getting value from a field based on a corresponding column in App Development

Getting value from a field based on a corresponding column

Anonymous — Wed, 21 Mar 2018 13:50:18 GMT

Hello, I'm struggling with something that seems very simple yet I spent quite some time on it and have not found a straightforward answer.

What I need to do is to extract a value from a table based on a value of a corresponding column. The table has 2 columns: id and name. I want to use it for labelling measures on a chart which is based on various tables. So it would be something like = name(id=2). Can someone help?

Re: Getting value from a field based on a corresponding column

sunny_talwar — Wed, 21 Mar 2018 16:04:27 GMT

May be this

Concat(DISTINCT {<id = {2}>}name)

Only({<id = {2}>}name)

Re: Getting value from a field based on a corresponding column

Anonymous — Thu, 22 Mar 2018 12:26:15 GMT

Thanks, I used the second one and it did the trick 🙂