topic Re: Sum distinct in set expression? in QlikView https://community.qlik.com/t5/QlikView/Sum-distinct-in-set-expression/m-p/1453281#M796216 <HTML><HEAD></HEAD><BODY><P>Thanks, it works!</P></BODY></HTML> Fri, 22 Dec 2017 15:52:29 GMT Anonymous 2017-12-22T15:52:29Z Sum distinct in set expression? https://community.qlik.com/t5/QlikView/Sum-distinct-in-set-expression/m-p/1453279#M796214 <HTML><HEAD></HEAD><BODY><P>Hello, assuming I have the following table </P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Computer_ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Date_Used</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">On_State</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1.01.2017</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1.01.2017</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">1.01.2017</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1.01.2017</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1.01.2017</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1.01.2017</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">3.01.2017</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P>how can I sum all the days all the computers have been used on "On_State" = 1 without adding the duplicates? Is there any way to use DISTINCT in Sum's Set Expression? </P><P>I'm looking for the following output for the said expression(in a PivotTable), given the table above:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Computer_ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Days_used</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">2</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sum-distinct-in-set-expression/m-p/1453279#M796214 Anonymous 2020-11-25T16:16:04Z Re: Sum distinct in set expression? https://community.qlik.com/t5/QlikView/Sum-distinct-in-set-expression/m-p/1453280#M796215 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Count(DISTINCT Date_Used)</STRONG></P></BODY></HTML> Fri, 22 Dec 2017 15:44:34 GMT https://community.qlik.com/t5/QlikView/Sum-distinct-in-set-expression/m-p/1453280#M796215 sunny_talwar 2017-12-22T15:44:34Z Re: Sum distinct in set expression? https://community.qlik.com/t5/QlikView/Sum-distinct-in-set-expression/m-p/1453281#M796216 <HTML><HEAD></HEAD><BODY><P>Thanks, it works!</P></BODY></HTML> Fri, 22 Dec 2017 15:52:29 GMT https://community.qlik.com/t5/QlikView/Sum-distinct-in-set-expression/m-p/1453281#M796216 Anonymous 2017-12-22T15:52:29Z