topic Re: Dimension aggregation in App Development https://community.qlik.com/t5/App-Development/Dimension-aggregation/m-p/1292060#M27256 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>CONCAT(DISTINCT ROLE,',')</P></BODY></HTML> Wed, 23 Nov 2016 04:52:43 GMT shraddha_g 2016-11-23T04:52:43Z Dimension aggregation https://community.qlik.com/t5/App-Development/Dimension-aggregation/m-p/1292058#M27254 <HTML><HEAD></HEAD><BODY><P>Can someone help me with this. I am trying to achieve what is mentioned below.</P><P></P><P>Please share how to get done on qliksense from UI.&nbsp;&nbsp; </P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="width: 359px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Input</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"></TH></TR><TR><TD height="19" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">ID</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">NAME </TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">CITY </TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">ROLE </TD></TR><TR><TD align="right" height="19" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">NITESHA </TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">DALLAS</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Director</TD></TR><TR><TD align="right" height="19" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">NITESHA </TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">DALLAS</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"><P>Senior Manager </P><P></P></TD></TR><TR><TD class="xl65" height="19" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"><STRONG>output </STRONG></TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD height="19" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">ID</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">NAME </TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">CITY </TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">ROLE </TD></TR><TR><TD align="right" height="19" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">NITESHA </TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">DALLAS</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Director , Senior Manager </TD></TR></TBODY></TABLE></BODY></HTML> Tue, 22 Nov 2016 15:34:59 GMT https://community.qlik.com/t5/App-Development/Dimension-aggregation/m-p/1292058#M27254 2016-11-22T15:34:59Z Re: Dimension aggregation https://community.qlik.com/t5/App-Development/Dimension-aggregation/m-p/1292059#M27255 <HTML><HEAD></HEAD><BODY><P>I want the out role should be&nbsp; like . It must be separated by chr(13)</P><P></P><P>Director</P><P>Senior Manager </P></BODY></HTML> Tue, 22 Nov 2016 16:52:08 GMT https://community.qlik.com/t5/App-Development/Dimension-aggregation/m-p/1292059#M27255 2016-11-22T16:52:08Z Re: Dimension aggregation https://community.qlik.com/t5/App-Development/Dimension-aggregation/m-p/1292060#M27256 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>CONCAT(DISTINCT ROLE,',')</P></BODY></HTML> Wed, 23 Nov 2016 04:52:43 GMT https://community.qlik.com/t5/App-Development/Dimension-aggregation/m-p/1292060#M27256 shraddha_g 2016-11-23T04:52:43Z Re: Dimension aggregation https://community.qlik.com/t5/App-Development/Dimension-aggregation/m-p/1292061#M27257 <HTML><HEAD></HEAD><BODY><P>Expression Concat(DISTINCT ROLE, chr(13)) </P><P>Dimension ID</P></BODY></HTML> Wed, 23 Nov 2016 04:57:42 GMT https://community.qlik.com/t5/App-Development/Dimension-aggregation/m-p/1292061#M27257 jonathandienst 2016-11-23T04:57:42Z