topic Re: trying to do sums with count I need some help please? in QlikView https://community.qlik.com/t5/QlikView/trying-to-do-sums-with-count-I-need-some-help-please/m-p/475287#M177468 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this one.</P><P></P><P>Ex:</P><P></P><P>=Count(DISTINCT if((sum(BILL_DOLLARS)/sum(AVAIL_DOLLARS))&lt;=$(vBillSlider),EmployeeID))</P><P></P><P></P><P>Else </P><P></P><P>try this in set analysis.</P><P></P><P></P><P>=count(DISTINCT {$&lt;EmployeeID={"=$(=(sum(BILL_DOLLARS)/sum(AVAIL_DOLLARS)) &lt;= $(vBillSlider))"}&gt;}EmployeeID) </P></BODY></HTML> Mon, 17 Jun 2013 06:02:18 GMT kumarnatarajan 2013-06-17T06:02:18Z trying to do sums with count I need some help please? https://community.qlik.com/t5/QlikView/trying-to-do-sums-with-count-I-need-some-help-please/m-p/475284#M177465 <HTML><HEAD></HEAD><BODY><P>count({sum((BILL_DOLLARS)/sum(AVAIL_DOLLARS))&lt;=$(vBillSlider)}EmployeeID)&nbsp; any help would be appreciated please</P></BODY></HTML> Mon, 17 Jun 2013 00:08:30 GMT https://community.qlik.com/t5/QlikView/trying-to-do-sums-with-count-I-need-some-help-please/m-p/475284#M177465 2013-06-17T00:08:30Z Re: trying to do sums with count I need some help please? https://community.qlik.com/t5/QlikView/trying-to-do-sums-with-count-I-need-some-help-please/m-p/475285#M177466 <HTML><HEAD></HEAD><BODY><P>Why using count when already using SUM()</P></BODY></HTML> Mon, 17 Jun 2013 05:53:07 GMT https://community.qlik.com/t5/QlikView/trying-to-do-sums-with-count-I-need-some-help-please/m-p/475285#M177466 sujeetsingh 2013-06-17T05:53:07Z Re: trying to do sums with count I need some help please? https://community.qlik.com/t5/QlikView/trying-to-do-sums-with-count-I-need-some-help-please/m-p/475286#M177467 <HTML><HEAD></HEAD><BODY><P>try this</P><P><STRONG>Count(if((BILL_DOLLARS / AVAIL_DOLLARS)&lt;=$(vBillSlider),EmployeeID))</STRONG></P></BODY></HTML> Mon, 17 Jun 2013 05:56:37 GMT https://community.qlik.com/t5/QlikView/trying-to-do-sums-with-count-I-need-some-help-please/m-p/475286#M177467 2013-06-17T05:56:37Z Re: trying to do sums with count I need some help please? https://community.qlik.com/t5/QlikView/trying-to-do-sums-with-count-I-need-some-help-please/m-p/475287#M177468 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this one.</P><P></P><P>Ex:</P><P></P><P>=Count(DISTINCT if((sum(BILL_DOLLARS)/sum(AVAIL_DOLLARS))&lt;=$(vBillSlider),EmployeeID))</P><P></P><P></P><P>Else </P><P></P><P>try this in set analysis.</P><P></P><P></P><P>=count(DISTINCT {$&lt;EmployeeID={"=$(=(sum(BILL_DOLLARS)/sum(AVAIL_DOLLARS)) &lt;= $(vBillSlider))"}&gt;}EmployeeID) </P></BODY></HTML> Mon, 17 Jun 2013 06:02:18 GMT https://community.qlik.com/t5/QlikView/trying-to-do-sums-with-count-I-need-some-help-please/m-p/475287#M177468 kumarnatarajan 2013-06-17T06:02:18Z