topic Field values that equals dimension values in QlikView https://community.qlik.com/t5/QlikView/Field-values-that-equals-dimension-values/m-p/728010#M260899 <HTML><HEAD></HEAD><BODY><P>I am trying to get values from Field3 based on the values in my table dimension.</P><P></P><P>Table Dimension: Field1</P><P>Expression: = sum({&lt;Field2=P(Field1)&gt;} Field3) // I wish to look up field 3 values where the Field 2 values matches the current row value of Field 1</P><P></P><P>Field2: Linked with Field 1 in the data model (this link must perhaps be "disconnected" by set analysis to be able to access Field3). </P><P></P><P>Field3: The value I with to have summarized per line where Field 1 = Field 2 (Field 3 and Field 2 are in one table, Field One and Field 2 are in another)</P><P></P><P>Any ideas? Very grateful for any help!</P><P></P><P>Christian</P></BODY></HTML> Wed, 29 Oct 2014 21:59:44 GMT Christian_Lauritzen 2014-10-29T21:59:44Z Field values that equals dimension values https://community.qlik.com/t5/QlikView/Field-values-that-equals-dimension-values/m-p/728010#M260899 <HTML><HEAD></HEAD><BODY><P>I am trying to get values from Field3 based on the values in my table dimension.</P><P></P><P>Table Dimension: Field1</P><P>Expression: = sum({&lt;Field2=P(Field1)&gt;} Field3) // I wish to look up field 3 values where the Field 2 values matches the current row value of Field 1</P><P></P><P>Field2: Linked with Field 1 in the data model (this link must perhaps be "disconnected" by set analysis to be able to access Field3). </P><P></P><P>Field3: The value I with to have summarized per line where Field 1 = Field 2 (Field 3 and Field 2 are in one table, Field One and Field 2 are in another)</P><P></P><P>Any ideas? Very grateful for any help!</P><P></P><P>Christian</P></BODY></HTML> Wed, 29 Oct 2014 21:59:44 GMT https://community.qlik.com/t5/QlikView/Field-values-that-equals-dimension-values/m-p/728010#M260899 Christian_Lauritzen 2014-10-29T21:59:44Z