Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ 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

Discount is Distinct right?

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

Not applicable
Author

thanks ! sorry for the typo !