Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to group by concatenated field to use aggregations?

Hi

in my Qlikview script i have this:

LOAD
[name]& '-' & [birthdate] as key,
Grade,
year,
Date,

and lots of other fields

So when i use things like min(date) i need to have a group by function, normally i just use "name" to group by but in this table i needed "name" to concatenate with "birthdate" to make it unique... but i just can't use GROUP BY [name]& '-' & [birthdate]; that doesn't work...

somebody knows a solution for this?

1 Reply
Not applicable
Author

it's okay 🙂 fixed it myself with some resident loads