topic Connecting data in straight table between two tables in QlikView https://community.qlik.com/t5/QlikView/Connecting-data-in-straight-table-between-two-tables/m-p/1037052#M349497 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Let's say I have two tables:</P><P>1. Main table (called: main) - this table has few fields, including: "Date_Id" and "Country_Name"</P><P>2. Second table (called: dim) - this table has few fields, including: "Date_Id" and "Country"</P><P></P><P>The tables are connected by the field "Date_Id".</P><P></P><P>I have a dynamic straight table, based on the main table.</P><P>I want to create an expression in the table with the following constraint: "Country" = "Country_Name" (Only if one "Country_Name" is selected).</P><P></P><P>I tried the following set analysis: {&lt; Country={$(=MaxString(Country_Name)}&gt;} but it doesn't work once I add "Country_Name" as a dimension in the straight table.</P><P></P><P>Can you help?</P><P>Thanks!</P></BODY></HTML> Wed, 06 Jan 2016 14:27:14 GMT 2016-01-06T14:27:14Z Connecting data in straight table between two tables https://community.qlik.com/t5/QlikView/Connecting-data-in-straight-table-between-two-tables/m-p/1037052#M349497 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Let's say I have two tables:</P><P>1. Main table (called: main) - this table has few fields, including: "Date_Id" and "Country_Name"</P><P>2. Second table (called: dim) - this table has few fields, including: "Date_Id" and "Country"</P><P></P><P>The tables are connected by the field "Date_Id".</P><P></P><P>I have a dynamic straight table, based on the main table.</P><P>I want to create an expression in the table with the following constraint: "Country" = "Country_Name" (Only if one "Country_Name" is selected).</P><P></P><P>I tried the following set analysis: {&lt; Country={$(=MaxString(Country_Name)}&gt;} but it doesn't work once I add "Country_Name" as a dimension in the straight table.</P><P></P><P>Can you help?</P><P>Thanks!</P></BODY></HTML> Wed, 06 Jan 2016 14:27:14 GMT https://community.qlik.com/t5/QlikView/Connecting-data-in-straight-table-between-two-tables/m-p/1037052#M349497 2016-01-06T14:27:14Z Re: Connecting data in straight table between two tables https://community.qlik.com/t5/QlikView/Connecting-data-in-straight-table-between-two-tables/m-p/1037053#M349498 <HTML><HEAD></HEAD><BODY><P>I don't think you can use a set analysis expression for this. Try an if statement: Sum( if(Country=Country_Name, Amount))</P></BODY></HTML> Wed, 06 Jan 2016 17:48:59 GMT https://community.qlik.com/t5/QlikView/Connecting-data-in-straight-table-between-two-tables/m-p/1037053#M349498 Gysbert_Wassenaar 2016-01-06T17:48:59Z Re: Connecting data in straight table between two tables https://community.qlik.com/t5/QlikView/Connecting-data-in-straight-table-between-two-tables/m-p/1037054#M349499 <HTML><HEAD></HEAD><BODY><P>Worked. Thanks!</P></BODY></HTML> Thu, 07 Jan 2016 08:11:35 GMT https://community.qlik.com/t5/QlikView/Connecting-data-in-straight-table-between-two-tables/m-p/1037054#M349499 2016-01-07T08:11:35Z