topic Aggregate fields for specific value in one field in QlikView https://community.qlik.com/t5/QlikView/Aggregate-fields-for-specific-value-in-one-field/m-p/260712#M581463 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Stefan!</P></BODY></HTML> Mon, 09 Jan 2012 22:26:06 GMT Anonymous 2012-01-09T22:26:06Z Aggregate fields for specific value in one field https://community.qlik.com/t5/QlikView/Aggregate-fields-for-specific-value-in-one-field/m-p/260710#M581461 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>In my QlikView document I load customers and addresses. Sometimes customers do have more then one address.</P><P>The usual data display would be:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 75%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Customer</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Address</STRONG></SPAN></TH></TR><TR><TD>CUSTOMER1</TD><TD>ADRESS1</TD></TR><TR><TD>CUSTOMER1</TD><TD>ADRESS2</TD></TR></TBODY></TABLE><P></P><P></P><P>I would like to display the data as following:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 75%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 2</STRONG></SPAN></TH></TR><TR><TD>CUSTOMER1</TD><TD>ADRESS1, ADRESS2</TD></TR></TBODY></TABLE><P></P><P>Any thoughts on this?</P><P></P><P>Kind regards,</P><P>Henco</P></BODY></HTML> Mon, 09 Jan 2012 21:55:23 GMT https://community.qlik.com/t5/QlikView/Aggregate-fields-for-specific-value-in-one-field/m-p/260710#M581461 Anonymous 2012-01-09T21:55:23Z Aggregate fields for specific value in one field https://community.qlik.com/t5/QlikView/Aggregate-fields-for-specific-value-in-one-field/m-p/260711#M581462 <HTML><HEAD></HEAD><BODY><P>Try a </P><P></P><P>=concat(Address, ', ')</P><P></P><P>e.g. in a table chart.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Mon, 09 Jan 2012 22:12:08 GMT https://community.qlik.com/t5/QlikView/Aggregate-fields-for-specific-value-in-one-field/m-p/260711#M581462 swuehl 2012-01-09T22:12:08Z Aggregate fields for specific value in one field https://community.qlik.com/t5/QlikView/Aggregate-fields-for-specific-value-in-one-field/m-p/260712#M581463 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Stefan!</P></BODY></HTML> Mon, 09 Jan 2012 22:26:06 GMT https://community.qlik.com/t5/QlikView/Aggregate-fields-for-specific-value-in-one-field/m-p/260712#M581463 Anonymous 2012-01-09T22:26:06Z