topic Re: How to make this sum in QlikView https://community.qlik.com/t5/QlikView/How-to-make-this-sum/m-p/983292#M969341 <HTML><HEAD></HEAD><BODY><P>Thank you Nithin. It's work.</P></BODY></HTML> Fri, 18 Sep 2015 16:07:57 GMT 2015-09-18T16:07:57Z How to make this sum https://community.qlik.com/t5/QlikView/How-to-make-this-sum/m-p/983290#M969339 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>Could you help me to calculate&nbsp; "Nbre tickets résolus ". We can have it by make a filter on status='solved'.</P><P>The result is 2.I put in expression count(DISTINCT tickets_id), status='solved') but it's not correct.</P><P>How can i do it?</P><P></P><P>Thank you for your help.</P><P>Hello.</P><P></P><P>Could you help me to calculate&nbsp; "Nbre tickets résolus ". We can have it by make a filter on status='solved'.</P><P>The result is 2.I put in expression count(DISTINCT tickets_id), status='solved') but it's not correct.</P><P>How can i do it?</P><P></P><P>Thank you for your help.</P></BODY></HTML> Fri, 18 Sep 2015 15:51:08 GMT https://community.qlik.com/t5/QlikView/How-to-make-this-sum/m-p/983290#M969339 2015-09-18T15:51:08Z Re: How to make this sum https://community.qlik.com/t5/QlikView/How-to-make-this-sum/m-p/983291#M969340 <HTML><HEAD></HEAD><BODY><P>Hi Destin,</P><P></P><P>Try this Count({&lt;Status={'Solved'}&gt;}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DISTINCT tickets_id</SPAN>)</P><P></P><P>Thanks</P><P>Nithin</P></BODY></HTML> Fri, 18 Sep 2015 15:54:55 GMT https://community.qlik.com/t5/QlikView/How-to-make-this-sum/m-p/983291#M969340 2015-09-18T15:54:55Z Re: How to make this sum https://community.qlik.com/t5/QlikView/How-to-make-this-sum/m-p/983292#M969341 <HTML><HEAD></HEAD><BODY><P>Thank you Nithin. It's work.</P></BODY></HTML> Fri, 18 Sep 2015 16:07:57 GMT https://community.qlik.com/t5/QlikView/How-to-make-this-sum/m-p/983292#M969341 2015-09-18T16:07:57Z