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

Calculate the number of employees whose last letter of FIRST_NAME is 'a'.

Hi,

 

Can someone help me with calculating number of employees whose last letter of FIRST_NAME is 'a'.

 

TIA

Labels (3)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Count({<FIRST_NAME={"*a"}>}Distinct Employee)

-Rob

View solution in original post

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Count({<FIRST_NAME={"*a"}>}Distinct Employee)

-Rob

Sree_1
Contributor III
Contributor III
Author

Hi Rob,

 

Thanks for the solution. Can you please give one more set expression using the right() function?

 

Thank you,

Sree

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

In what case would you want to use the right function? 

-Rob

BrunPierre
Master
Master

I take it that you want an alternative using Right(), then perhaps as below.

=Count({$<FIRST_NAME= {"=Right(FIRST_NAME, 1) = 'a'"}>}DISTINCT Employee)