5 Replies Latest reply: Nov 21, 2012 5:49 AM by Thomas Jensen RSS

    Display name by using key

      I want to display a name by a ID, so i can identify if have 2 same names but with 2 different keys (ID)


      I got this expression


      =if(DWID_Medarbejder <> 1888, DWID_Medarbejder)


      This shows all my workers ID except 1888. How can i comebine a name on this?


      So i would get for an example

      "Thomas Jensen 454"

      "Michael Hansen 455"

      "Thomas Jensen 456"

      "Peter Pedersen 457"

      and so on


      And how do i do it in a bar chart? Is that just a calculated dimension?