Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
izmingazov
New Contributor III

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
MVP
MVP

Re: Get field value from unrelated table

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

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

Re: Get field value from unrelated table

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

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

Re: Get field value from unrelated table

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

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

izmingazov
New Contributor III

Re: Get field value from unrelated table

Thank you, Jonathan, that's what helpfull!

izmingazov
New Contributor III

Re: Get field value from unrelated table

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