Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

deepanshu_chamo1
New Contributor

Remove the unwanted name

Please help me to implement the below logic in Qlik Sense: I have the names as below: Abc.def@gmail.com A.de@ gmail.com Aaaaaaa.bbbbb@gmail.com... And so on.. I just want names as: Abc.def A.de Aaaaaaa.bbbbb Please help me Thanks Deepanshu

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Remove the unwanted name

seems like a typo with double quotes (after @) m w‌:

SubField(Email, '@', 1) as Name

3 Replies
mwoolf
Honored Contributor II

Re: Remove the unwanted name

If you Field is named Email:

subfield(Email,'@",1) as Name,

MVP
MVP

Re: Remove the unwanted name

seems like a typo with double quotes (after @) m w‌:

SubField(Email, '@', 1) as Name

deepanshu_chamo1
New Contributor

Re: Remove the unwanted name

Thanks for the help 

Regards Deepanshu