topic Re: Expression with NumericCount and Sum in QlikView

Expression with NumericCount and Sum

Anonymous — Wed, 27 Mar 2013 10:31:07 GMT

Could someone help me with this expression? As long as I keep the sum out of the expression it works fine, but the expression needs to have a sum of the Sales to exclude customers that due to a correction have a minus sales value that's equal to de plus sales value.

NumericCount

(DISTINCT{<Sum(Sales) = {">0"} ,PeriodYear = {$(vCurrentYear)}>} OrganisationID)

Re: Expression with NumericCount and Sum

Gysbert_Wassenaar — Wed, 27 Mar 2013 10:43:30 GMT

Try: NumericCount((DISTINCT {<OrganisationID={"=Sum(Sales)>0"} ,PeriodYear = {$(vCurrentYear)}>} OrganisationID)

Re: Expression with NumericCount and Sum

Anonymous — Wed, 27 Mar 2013 13:51:55 GMT

Thank you for your answer. It comes close but it isn't the solution. My original expression depends in all cases on currentyear. When I try your solution the numbers change when I select another year. Any idea?

Re: Expression with NumericCount and Sum

Anonymous — Wed, 10 Apr 2013 09:29:06 GMT

I have made a sample qvw. The part above is about the sales and the under the sales part there is information about the number of employes that have worked at a certain esthablishment and the total hours that the employes have worked.

The problem is that when I select the brand Skoda or Seat in the pie-chart the total worked hours change.

How can I ensure that the total worked hours don't respond on the car brand that I select?