topic Help with Sum distinct in QlikView https://community.qlik.com/t5/QlikView/Help-with-Sum-distinct/m-p/334646#M493267 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the following working exp:</P><P></P><P>sum({$ &lt;Type -= {'FLEET'}&gt;} if(TD_Commision = [Commission Number],1))</P><P></P><P>the problem is, there could be repeated data where for example&nbsp; TD_Commission can occur 20 times, and I am strugling how to add distinct funtion to it.</P><P></P><P>any ideas&nbsp; </P><P></P><P>thanks in advance</P></BODY></HTML> Sat, 02 Jun 2012 10:23:13 GMT 2012-06-02T10:23:13Z Help with Sum distinct https://community.qlik.com/t5/QlikView/Help-with-Sum-distinct/m-p/334646#M493267 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the following working exp:</P><P></P><P>sum({$ &lt;Type -= {'FLEET'}&gt;} if(TD_Commision = [Commission Number],1))</P><P></P><P>the problem is, there could be repeated data where for example&nbsp; TD_Commission can occur 20 times, and I am strugling how to add distinct funtion to it.</P><P></P><P>any ideas&nbsp; </P><P></P><P>thanks in advance</P></BODY></HTML> Sat, 02 Jun 2012 10:23:13 GMT https://community.qlik.com/t5/QlikView/Help-with-Sum-distinct/m-p/334646#M493267 2012-06-02T10:23:13Z Help with Sum distinct https://community.qlik.com/t5/QlikView/Help-with-Sum-distinct/m-p/334647#M493268 <HTML><HEAD></HEAD><BODY><P>What happens if you just add DISTINCT in the expression? </P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">sum(DISTINCT {$ &lt;Type -= {'FLEET'}&gt;} if(TD_Commision = [Commission Number],1))</SPAN></P></BODY></HTML> Sun, 03 Jun 2012 20:28:22 GMT https://community.qlik.com/t5/QlikView/Help-with-Sum-distinct/m-p/334647#M493268 ToniKautto 2012-06-03T20:28:22Z