topic Re: Get field value from unrelated table in QlikView https://community.qlik.com/t5/QlikView/Get-field-value-from-unrelated-table/m-p/1213500#M388914 <HTML><HEAD></HEAD><BODY><P>=Only({&lt;A = {'KPI3'}&gt;} B)</P></BODY></HTML> Wed, 21 Dec 2016 06:00:48 GMT jonathandienst 2016-12-21T06:00:48Z Get field value from unrelated table https://community.qlik.com/t5/QlikView/Get-field-value-from-unrelated-table/m-p/1213499#M388913 <HTML><HEAD></HEAD><BODY><P>Hi all.</P><P></P><P>I need to get field value from unrelated table by another field value in this table <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" />.</P><P>For example, we have table:</P><P>A&nbsp;&nbsp;&nbsp;&nbsp; B</P><P>----------</P><P>KPI1&nbsp;&nbsp;&nbsp; 55</P><P>KPI2<SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp; 100</SPAN></P><P><SPAN style="font-size: 10pt;">KPI3&nbsp;&nbsp;&nbsp;&nbsp; 55</SPAN></P><P>KPI4&nbsp;&nbsp;&nbsp;&nbsp; 99</P><P></P><P>How can i get the value (col B) for KPI3? Is it possible? </P><P>FieldValue(A, 3) solution is not good, because there are duplicated values in B column.</P><P></P><P>I'd appreciate any help.</P></BODY></HTML> Wed, 21 Dec 2016 04:06:37 GMT https://community.qlik.com/t5/QlikView/Get-field-value-from-unrelated-table/m-p/1213499#M388913 Anonymous 2016-12-21T04:06:37Z Re: Get field value from unrelated table https://community.qlik.com/t5/QlikView/Get-field-value-from-unrelated-table/m-p/1213500#M388914 <HTML><HEAD></HEAD><BODY><P>=Only({&lt;A = {'KPI3'}&gt;} B)</P></BODY></HTML> Wed, 21 Dec 2016 06:00:48 GMT https://community.qlik.com/t5/QlikView/Get-field-value-from-unrelated-table/m-p/1213500#M388914 jonathandienst 2016-12-21T06:00:48Z Re: Get field value from unrelated table https://community.qlik.com/t5/QlikView/Get-field-value-from-unrelated-table/m-p/1213501#M388915 <HTML><HEAD></HEAD><BODY><P>Use the Expression in Text Object&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Only({&lt;A = {'$(vSelect)'}&gt;} B)</SPAN></P><P></P><P>you have to create a variable and assign&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Getfieldselection(A) </P></BODY></HTML> Wed, 21 Dec 2016 06:24:24 GMT https://community.qlik.com/t5/QlikView/Get-field-value-from-unrelated-table/m-p/1213501#M388915 2016-12-21T06:24:24Z Re: Get field value from unrelated table https://community.qlik.com/t5/QlikView/Get-field-value-from-unrelated-table/m-p/1213502#M388916 <HTML><HEAD></HEAD><BODY><P>Thank you, Jonathan, that's what helpfull!</P></BODY></HTML> Thu, 22 Dec 2016 10:47:25 GMT https://community.qlik.com/t5/QlikView/Get-field-value-from-unrelated-table/m-p/1213502#M388916 Anonymous 2016-12-22T10:47:25Z Re: Get field value from unrelated table https://community.qlik.com/t5/QlikView/Get-field-value-from-unrelated-table/m-p/1213503#M388917 <HTML><HEAD></HEAD><BODY><P>Sorry, could explain how to check only result existense additionally?</P></BODY></HTML> Thu, 22 Dec 2016 11:31:40 GMT https://community.qlik.com/t5/QlikView/Get-field-value-from-unrelated-table/m-p/1213503#M388917 Anonymous 2016-12-22T11:31:40Z