Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
=if(zde_created_by=user_id,Person_Name)
Assigned to column:
=if(zde_assigned_user_id=user_id,Person_Name)
In the db the all the data is collected in one row per id, but when displayed in qlikview it is seperated per expression.
.png "Luminary Alumni"){kind=icon}