1 Reply Latest reply: Apr 4, 2012 6:00 AM by Jason Michaelides RSS

    Is there a way to merge rows in a table?

      as.bmp

       

      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.