Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Get field value from unrelated table

Hi all.

I need to get field value from unrelated table by another field value in this table .

For example, we have table:

A     B

----------

KPI1    55

KPI2    100

KPI3     55

KPI4     99

How can i get the value (col B) for KPI3? Is it possible?

FieldValue(A, 3) solution is not good, because there are duplicated values in B column.

I'd appreciate any help.

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

=Only({<A = {'KPI3'}>} B)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

=Only({<A = {'KPI3'}>} B)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Use the Expression in Text Object                          =Only({<A = {'$(vSelect)'}>} B)

you have to create a variable and assign                 Getfieldselection(A)

Anonymous
Not applicable
Author

Thank you, Jonathan, that's what helpfull!

Anonymous
Not applicable
Author

Sorry, could explain how to check only result existense additionally?