Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
marley1978
Contributor III
Contributor III

Counts Showing Incorrectly in charts

I have a measure where I use an expression of

Count ({< [Term] = {'Yes'}, [Term Reason] -= {'Unknown'}>} EmployeeID)

When I use this in a pivot table and group by YearMonth I get a total of 791 records which is correct.

When I use the same expression in a KPI I get 784 records.  Looks like its removing duplicate employeeIDs.  Duplicate records can occur since an employee can be termed more than once in a given period.

I am not sure what is going on since I am using the same master measure in both types of charts.

Any ideas why it would do this?

21 Replies
zebhashmi
Specialist
Specialist

try =-

instead of -=

marley1978
Contributor III
Contributor III
Author

same issue