topic Re: Problem with aggr() in App Development https://community.qlik.com/t5/App-Development/Problem-with-aggr/m-p/1391170#M32013 <HTML><HEAD></HEAD><BODY><P>The complete syntax was: </P><P></P><P>Aggr(Concat(DISTINCT Field_2, ','), Field_1)</P></BODY></HTML> Fri, 22 Sep 2017 07:49:08 GMT 2017-09-22T07:49:08Z Problem with aggr() https://community.qlik.com/t5/App-Development/Problem-with-aggr/m-p/1391168#M32011 <HTML><HEAD></HEAD><BODY><P>Hi to everyone,</P><P>I've a problem I can't solve. This is my table:</P><P></P><TABLE border="1" class="jiveBorder" height="249" style="border: 1px solid rgb(0, 0, 0); width: 108px; height: 225px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Field_1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Field_2</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">X</TD></TR><TR><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">-</TD></TR><TR><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">X</TD></TR><TR><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">-</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">-</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">X</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">-</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">-</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">Y</TD></TR></TBODY></TABLE><P></P><P>this is what I need to obtain:</P><P></P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid rgb(0, 0, 0); width: 102px; height: 44px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Field_1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Field_2</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">X</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">X, Y</TD></TR></TBODY></TABLE><P></P><P>Using the Aggr() function: </P><P></P><P>Aggr(Field_2,Field_1)</P><P></P><P>I'm only able to obtain this:</P><P></P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid rgb(0, 0, 0); width: 101px; height: 39px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Field_1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Field_2</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">X</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">-</TD></TR></TBODY></TABLE><P></P><P>How can I extract also the 'Y'?</P><P></P><P>Thanks a lot!</P></BODY></HTML> Thu, 21 Sep 2017 15:12:38 GMT https://community.qlik.com/t5/App-Development/Problem-with-aggr/m-p/1391168#M32011 2017-09-21T15:12:38Z Re: Problem with aggr() https://community.qlik.com/t5/App-Development/Problem-with-aggr/m-p/1391169#M32012 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>Concat(DISTINCT Field_2, ', ')</STRONG></P></BODY></HTML> Thu, 21 Sep 2017 17:11:13 GMT https://community.qlik.com/t5/App-Development/Problem-with-aggr/m-p/1391169#M32012 sunny_talwar 2017-09-21T17:11:13Z Re: Problem with aggr() https://community.qlik.com/t5/App-Development/Problem-with-aggr/m-p/1391170#M32013 <HTML><HEAD></HEAD><BODY><P>The complete syntax was: </P><P></P><P>Aggr(Concat(DISTINCT Field_2, ','), Field_1)</P></BODY></HTML> Fri, 22 Sep 2017 07:49:08 GMT https://community.qlik.com/t5/App-Development/Problem-with-aggr/m-p/1391170#M32013 2017-09-22T07:49:08Z Re: Problem with aggr() https://community.qlik.com/t5/App-Development/Problem-with-aggr/m-p/1391171#M32014 <HTML><HEAD></HEAD><BODY><P>Great thanks!</P></BODY></HTML> Fri, 22 Sep 2017 13:02:26 GMT https://community.qlik.com/t5/App-Development/Problem-with-aggr/m-p/1391171#M32014 2017-09-22T13:02:26Z Re: Problem with aggr() https://community.qlik.com/t5/App-Development/Problem-with-aggr/m-p/1391172#M32015 <HTML><HEAD></HEAD><BODY><P>Were you using this as a dimension?</P></BODY></HTML> Fri, 22 Sep 2017 15:20:39 GMT https://community.qlik.com/t5/App-Development/Problem-with-aggr/m-p/1391172#M32015 sunny_talwar 2017-09-22T15:20:39Z