topic Re: Sum distinct by customer in QlikView https://community.qlik.com/t5/QlikView/Sum-distinct-by-customer/m-p/7262#M790513 <HTML><HEAD></HEAD><BODY><P>whaoo , thanks Sunny.</P><P>What is Dimensionality ? works very fine !!</P></BODY></HTML> Thu, 25 Jan 2018 18:07:00 GMT maxime66 2018-01-25T18:07:00Z Sum distinct by customer https://community.qlik.com/t5/QlikView/Sum-distinct-by-customer/m-p/7260#M790511 <HTML><HEAD></HEAD><BODY><P>Hi Qlikers.</P><P></P><P>I would like to get in the total line of the graphic attached 5 products (and not 7)</P><P>I tried Aggr stuff but it removes some lines ( i need to keep all the 4 rows displayed) </P><P>i also tried "sum( distinct [Nb product] ) " but&nbsp; it make distinct on customer 23 and 50.</P><P></P><P>any ideas ?</P><P></P><P>thanx</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sum-distinct-by-customer/m-p/7260#M790511 maxime66 2020-11-25T16:16:04Z Re: Sum distinct by customer https://community.qlik.com/t5/QlikView/Sum-distinct-by-customer/m-p/7261#M790512 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=If(Dimensionality() = 0, Sum(Aggr(Sum(DISTINCT [nb product]), customer)), Sum([nb product]))</STRONG></P></BODY></HTML> Thu, 25 Jan 2018 17:30:47 GMT https://community.qlik.com/t5/QlikView/Sum-distinct-by-customer/m-p/7261#M790512 sunny_talwar 2018-01-25T17:30:47Z Re: Sum distinct by customer https://community.qlik.com/t5/QlikView/Sum-distinct-by-customer/m-p/7262#M790513 <HTML><HEAD></HEAD><BODY><P>whaoo , thanks Sunny.</P><P>What is Dimensionality ? works very fine !!</P></BODY></HTML> Thu, 25 Jan 2018 18:07:00 GMT https://community.qlik.com/t5/QlikView/Sum-distinct-by-customer/m-p/7262#M790513 maxime66 2018-01-25T18:07:00Z Re: Sum distinct by customer https://community.qlik.com/t5/QlikView/Sum-distinct-by-customer/m-p/7263#M790514 <HTML><HEAD></HEAD><BODY><P>Look here</P><P><A href="https://community.qlik.com/docs/DOC-7969">How to use - Dimensionality()</A></P></BODY></HTML> Thu, 25 Jan 2018 18:15:02 GMT https://community.qlik.com/t5/QlikView/Sum-distinct-by-customer/m-p/7263#M790514 sunny_talwar 2018-01-25T18:15:02Z