topic Aggr in QlikView https://community.qlik.com/t5/QlikView/Aggr/m-p/1196212#M878718 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would bring the metric ( value 749) in the column title (dimension A20) near "Aeg" , the metric is:</P><P>Count({&lt;Q20=&gt;}TOTAL &lt;A20&gt; DISTINCT Person_20) where Q20 is the dimension for lines and Q20 is the dimension for columns (in the picture there is a only value for simplicity).</P><P>thanks for any suggested</P><P> <IMG alt="aggr.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/140524_aggr.PNG" style="height: 441px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT cirodem2015 2020-11-25T16:16:04Z Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/1196212#M878718 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would bring the metric ( value 749) in the column title (dimension A20) near "Aeg" , the metric is:</P><P>Count({&lt;Q20=&gt;}TOTAL &lt;A20&gt; DISTINCT Person_20) where Q20 is the dimension for lines and Q20 is the dimension for columns (in the picture there is a only value for simplicity).</P><P>thanks for any suggested</P><P> <IMG alt="aggr.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/140524_aggr.PNG" style="height: 441px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/1196212#M878718 cirodem2015 2020-11-25T16:16:04Z Re: Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/1196213#M878719 <HTML><HEAD></HEAD><BODY><P>Both the dimensions are Q20?</P></BODY></HTML> Thu, 13 Oct 2016 17:07:07 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/1196213#M878719 sunny_talwar 2016-10-13T17:07:07Z Re: Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/1196214#M878720 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P>sorry ..the dimension for columns is A20.....</P></BODY></HTML> Fri, 14 Oct 2016 07:36:40 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/1196214#M878720 cirodem2015 2016-10-14T07:36:40Z Re: Aggr https://community.qlik.com/t5/QlikView/Aggr/m-p/1196215#M878721 <HTML><HEAD></HEAD><BODY><P>Sorry, the dimension for columns is A20 !!</P></BODY></HTML> Fri, 14 Oct 2016 07:37:38 GMT https://community.qlik.com/t5/QlikView/Aggr/m-p/1196215#M878721 cirodem2015 2016-10-14T07:37:38Z