Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Bubskim
Contributor II
Contributor II

I need to concat or aggregate two similar values so they show up as one

Hi all,

How do I concat this example?

Email - example@gmail.com

email- example

both emails are the same the one has the @gmail.com at the end. I need to join them to display as one in my chart. This can be in the load or in the expression. 

Aggr(If((Count(DISTINCT)["example", "example@gmail.com"]) = ERROR

Count(DISTINCT)["example", "example@gmail.com"]) = ERROR

capture shows the issue

 

1 Reply
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Hi,

Attached is the requirement you looking for:

Concat.PNG

 

Thanks and regards,

Arthur Fong