Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

count discount with conditions

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

3 Replies
swuehl
MVP
MVP

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
Partner - Champion
Partner - Champion

Discount is Distinct right?

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

Not applicable
Author

thanks ! sorry for the typo !