topic amazing aggr in QlikView https://community.qlik.com/t5/QlikView/amazing-aggr/m-p/186223#M505354 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>why, in the last column I only have the first line of the "arrondissement" which is correct? and how can i modify to have all the cells full.</P><P>Thanks for your lights!</P><P>PS: i'm in QV9</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-432_sourceID:432" /></P></BODY></HTML> Mon, 14 Sep 2009 23:22:42 GMT adelmeire 2009-09-14T23:22:42Z amazing aggr https://community.qlik.com/t5/QlikView/amazing-aggr/m-p/186223#M505354 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>why, in the last column I only have the first line of the "arrondissement" which is correct? and how can i modify to have all the cells full.</P><P>Thanks for your lights!</P><P>PS: i'm in QV9</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-432_sourceID:432" /></P></BODY></HTML> Mon, 14 Sep 2009 23:22:42 GMT https://community.qlik.com/t5/QlikView/amazing-aggr/m-p/186223#M505354 adelmeire 2009-09-14T23:22:42Z amazing aggr https://community.qlik.com/t5/QlikView/amazing-aggr/m-p/186224#M505355 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try using the NODISTINCT keyword in your AGGR.</P><P></P><P>Stephen</P></BODY></HTML> Tue, 15 Sep 2009 00:05:19 GMT https://community.qlik.com/t5/QlikView/amazing-aggr/m-p/186224#M505355 stephencredmond 2009-09-15T00:05:19Z Re. :Re: amazing aggr https://community.qlik.com/t5/QlikView/amazing-aggr/m-p/186225#M505356 <HTML><HEAD></HEAD><BODY><P>Perfect!</P><P>thank u</P></BODY></HTML> Tue, 15 Sep 2009 14:18:25 GMT https://community.qlik.com/t5/QlikView/amazing-aggr/m-p/186225#M505356 adelmeire 2009-09-15T14:18:25Z