topic How to bring data located in an specific row in QlikView https://community.qlik.com/t5/QlikView/How-to-bring-data-located-in-an-specific-row/m-p/1430001#M610230 <HTML><HEAD></HEAD><BODY><P>Please help me to figure out this.</P><P></P><P>I have this table:</P><P></P><P>Age&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Policy</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1234</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12345</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3456&nbsp;&nbsp;&nbsp;&nbsp; </P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34567</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 345678</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 412</P><P></P><P>I want to concatenate in a text box all the Policies when I select any Age </P><P></P><P>Example:</P><P></P><P>Selected Field (Age) : 1</P><P></P><P>Text box = 1234 </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12345</P><P></P><P>Selected Field(Age): 3</P><P></P><P>Text box: 3456</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34567</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 345678</P><P></P><P>Thanks</P></BODY></HTML> Tue, 19 Dec 2017 16:27:18 GMT jaarroyl 2017-12-19T16:27:18Z How to bring data located in an specific row https://community.qlik.com/t5/QlikView/How-to-bring-data-located-in-an-specific-row/m-p/1430001#M610230 <HTML><HEAD></HEAD><BODY><P>Please help me to figure out this.</P><P></P><P>I have this table:</P><P></P><P>Age&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Policy</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1234</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12345</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3456&nbsp;&nbsp;&nbsp;&nbsp; </P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34567</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 345678</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 412</P><P></P><P>I want to concatenate in a text box all the Policies when I select any Age </P><P></P><P>Example:</P><P></P><P>Selected Field (Age) : 1</P><P></P><P>Text box = 1234 </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12345</P><P></P><P>Selected Field(Age): 3</P><P></P><P>Text box: 3456</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34567</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 345678</P><P></P><P>Thanks</P></BODY></HTML> Tue, 19 Dec 2017 16:27:18 GMT https://community.qlik.com/t5/QlikView/How-to-bring-data-located-in-an-specific-row/m-p/1430001#M610230 jaarroyl 2017-12-19T16:27:18Z Re: How to bring data located in an specific row https://community.qlik.com/t5/QlikView/How-to-bring-data-located-in-an-specific-row/m-p/1430002#M610231 <HTML><HEAD></HEAD><BODY><P>Try this expression</P><P></P><P><STRONG>Concat(DISTINCT Policy, Chr(10))</STRONG></P></BODY></HTML> Tue, 19 Dec 2017 16:28:42 GMT https://community.qlik.com/t5/QlikView/How-to-bring-data-located-in-an-specific-row/m-p/1430002#M610231 sunny_talwar 2017-12-19T16:28:42Z Re: How to bring data located in an specific row https://community.qlik.com/t5/QlikView/How-to-bring-data-located-in-an-specific-row/m-p/1430003#M610232 <HTML><HEAD></HEAD><BODY><P>Thanks, always the best!</P></BODY></HTML> Tue, 19 Dec 2017 18:11:31 GMT https://community.qlik.com/t5/QlikView/How-to-bring-data-located-in-an-specific-row/m-p/1430003#M610232 jaarroyl 2017-12-19T18:11:31Z