https://community.qlik.com/t5/QlikView/Use-an-value-from-a-second-table-in-an-Expression-which/m-p/1595993#M737700 <P>Hi,</P><P>Just to clarify. Tables you are writing about are already in your data model inside Qlik or in your source data?</P><P>In order to associate tables in Qlik, there must be at least one common field / identifier in both tables and it must have the same label (header).</P><P>If you have your output form some statistical engine, like for example R, than it can be that you'll have to add a rowID to both tables, that is if they have the same cardinality (same number of rows in both tables).</P><P>But anyway, for more specific answer you would have to provide more details.</P><P>Radovan</P> Wed, 26 Jun 2019 05:35:06 GMT RadovanOresky 2019-06-26T05:35:06Z https://community.qlik.com/t5/QlikView/Use-an-value-from-a-second-table-in-an-Expression-which/m-p/1595973#M737699 <P>I have two tables available. From one table I do some statistics like Number of result(n), Average and Standard Deviation.<BR />Now I should calculate an value using the Average, Standard deviation and an K-value form which the value depends on how big the number of results (n) are. So the second table contains each possible n value and its corresponding K-value.&nbsp;</P><P>How can I generate an expression which will search for the right k-value for each row in my table which has an different n value?</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Use-an-value-from-a-second-table-in-an-Expression-which/m-p/1595973#M737699 ArjanW 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Use-an-value-from-a-second-table-in-an-Expression-which/m-p/1595993#M737700 <P>Hi,</P><P>Just to clarify. Tables you are writing about are already in your data model inside Qlik or in your source data?</P><P>In order to associate tables in Qlik, there must be at least one common field / identifier in both tables and it must have the same label (header).</P><P>If you have your output form some statistical engine, like for example R, than it can be that you'll have to add a rowID to both tables, that is if they have the same cardinality (same number of rows in both tables).</P><P>But anyway, for more specific answer you would have to provide more details.</P><P>Radovan</P> Wed, 26 Jun 2019 05:35:06 GMT https://community.qlik.com/t5/QlikView/Use-an-value-from-a-second-table-in-an-Expression-which/m-p/1595993#M737700 RadovanOresky 2019-06-26T05:35:06Z https://community.qlik.com/t5/QlikView/Use-an-value-from-a-second-table-in-an-Expression-which/m-p/1596011#M737701 <P>Hello Radoresky, Thank you for your answer!<BR /><BR />Yes both tables are inside my data model.<BR /><BR />See attached image for (i hope) an more detailed stuation overview.</P> Wed, 26 Jun 2019 06:26:48 GMT https://community.qlik.com/t5/QlikView/Use-an-value-from-a-second-table-in-an-Expression-which/m-p/1596011#M737701 ArjanW 2019-06-26T06:26:48Z https://community.qlik.com/t5/QlikView/Use-an-value-from-a-second-table-in-an-Expression-which/m-p/1599063#M737702 <P>Hi,</P><P>And are these two tables associated in Qlik data model?</P><P>Because that is necessary, if you want to make a calculation with one field by a dimension from a different table.</P><P>If not and if the records align exactly as is shown on the picture, than I suggest you use RecNo() function when you load the second table and give it an alias "nk".</P><P><STRONG>Table2: load *, recno() as nk from</STRONG>...</P><P>Hope this helps.</P><P>Radovan</P> Thu, 04 Jul 2019 11:59:25 GMT https://community.qlik.com/t5/QlikView/Use-an-value-from-a-second-table-in-an-Expression-which/m-p/1599063#M737702 RadovanOresky 2019-07-04T11:59:25Z