Can I merge these records where the id are the same?
In the database 'Created by' and 'Assigned to' are id's in the 'zopus' table. I use these id's to pull the names (displayed above) from a diferent table called 'users'; using expressions as a dimensions.
Created by column:
Assigned to column:
In the db the all the data is collected in one row per id, but when displayed in qlikview it is seperated per expression.