topic Re: How to aggregate data across a dimension in QlikView https://community.qlik.com/t5/QlikView/How-to-aggregate-data-across-a-dimension/m-p/517674#M1122069 <HTML><HEAD></HEAD><BODY><P>Check if fits your needs</P></BODY></HTML> Wed, 15 Jan 2014 15:39:20 GMT Clever_Anjos 2014-01-15T15:39:20Z How to aggregate data across a dimension https://community.qlik.com/t5/QlikView/How-to-aggregate-data-across-a-dimension/m-p/517673#M1122068 <HTML><HEAD></HEAD><BODY><P><BR />I have two dimensions:&nbsp; class &amp; category.</P><P></P><P>I want to create a stacked bar chart that shows the % distribution of category within each class.&nbsp; I am able to create a stacked chart of the raw counts&nbsp; of ids for each category within class, but can't figure out how to get the total count of ids within class.&nbsp; I have tried</P><P>count(aggr(id),category) but that didn't work.&nbsp; Any suggestions? </P></BODY></HTML> Wed, 15 Jan 2014 15:36:44 GMT https://community.qlik.com/t5/QlikView/How-to-aggregate-data-across-a-dimension/m-p/517673#M1122068 2014-01-15T15:36:44Z Re: How to aggregate data across a dimension https://community.qlik.com/t5/QlikView/How-to-aggregate-data-across-a-dimension/m-p/517674#M1122069 <HTML><HEAD></HEAD><BODY><P>Check if fits your needs</P></BODY></HTML> Wed, 15 Jan 2014 15:39:20 GMT https://community.qlik.com/t5/QlikView/How-to-aggregate-data-across-a-dimension/m-p/517674#M1122069 Clever_Anjos 2014-01-15T15:39:20Z Re: How to aggregate data across a dimension https://community.qlik.com/t5/QlikView/How-to-aggregate-data-across-a-dimension/m-p/517675#M1122070 <HTML><HEAD></HEAD><BODY><P><BR />Thanks! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 15 Jan 2014 16:08:50 GMT https://community.qlik.com/t5/QlikView/How-to-aggregate-data-across-a-dimension/m-p/517675#M1122070 2014-01-15T16:08:50Z Re: How to aggregate data across a dimension https://community.qlik.com/t5/QlikView/How-to-aggregate-data-across-a-dimension/m-p/517676#M1122071 <HTML><HEAD></HEAD><BODY><P>Try this one</P><P>count(Total &lt;ID&gt; Category)</P></BODY></HTML> Wed, 15 Jan 2014 16:12:20 GMT https://community.qlik.com/t5/QlikView/How-to-aggregate-data-across-a-dimension/m-p/517676#M1122071 nizamsha 2014-01-15T16:12:20Z