Solved: I want to count employee code - Qlik Community - 2067118

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

I want to count Employee code that starts with 3, what should I do?

1 Solution

Accepted Solutions

=Count(DISTINCT {<EmployeeID= {"=Left(EmployeeID,1) = 3"}>} EmployeeID)

View solution in original post

1 Reply

=Count(DISTINCT {<EmployeeID= {"=Left(EmployeeID,1) = 3"}>} EmployeeID)