count discount with conditions - Qlik Community

Report Inappropriate Content · ‎2013-10-16

What is a correct formula with a countdiscount on field Headcount and the conditions are a list of codes.

So count(discount(Headcount) if departmentcode <> 1234 or departmentcode <> 2234 etc

Thanks

swuehl · ‎2013-10-16

What is a count discount? Sorry, I don't understand. Do you want to do a DISTINCT count?

=COUNT( DISTINCT IF(departmentcode <> 1234 or departmentcode <> 2234, Headcount))

CELAMBARASAN · ‎2013-10-16

Discount is Distinct right?

Count({<departmentcode-={1234, 2234}>}Distinct Headcount)

Report Inappropriate Content · ‎2013-10-16

thanks ! sorry for the typo !