Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

malina17
New Contributor II

Getting value from a field based on a corresponding column

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?

1 Solution

Accepted Solutions
MVP
MVP

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

May be this

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

or

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

2 Replies
MVP
MVP

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

May be this

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

or

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

malina17
New Contributor II

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

Thanks, I used the second one and it did the trick :-)

Community Browser