Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
hammermill21
Not applicable

Distinct Names & Unifying different letter case names

Hello!

I'm trying to create a filter with the function "first_last_name" to show the distinct names but also to unify when the names have different letter cases. So I have the name Randy Joubert then I have it again as Randy joubert and I need to combine them in some way. Is that possible?

Thank you!

1 Solution

Accepted Solutions
rupamjyotidas
Not applicable

Re: Distinct Names & Unifying different letter case names

user

capitalize(first_last_name) as first_last_name


or


Upper(first_last_name) as first_last_name

6 Replies
dan_sullivan
Not applicable

Re: Distinct Names & Unifying different letter case names

UPPER(first_last_name)  then they will be the same and you can do a distinct on them

rupamjyotidas
Not applicable

Re: Distinct Names & Unifying different letter case names

user

capitalize(first_last_name) as first_last_name


or


Upper(first_last_name) as first_last_name

hammermill21
Not applicable

Re: Distinct Names & Unifying different letter case names

Thanks Rupam, but I'm getting "Error in expression" 

rupamjyotidas
Not applicable

Re: Distinct Names & Unifying different letter case names

what is the expression you are using

hammermill21
Not applicable

Re: Distinct Names & Unifying different letter case names

You were right, I made a mistake in my expression. Thank you!

hammermill21
Not applicable

Re: Distinct Names & Unifying different letter case names

Thank you!