Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
it's okay 🙂 fixed it myself with some resident loads