3 Replies Latest reply: Jul 13, 2017 8:25 AM by Daniel Berkes RSS

    3 Coloms with the same type of data in 1 Dimension

    Erwin Vullers

      Hi there,


      I have a Excel sheet with Employees, and 3 colomns with the teams they are part of (no all emplyees are membert of 3 teams)


      I want to use a Filter Pane in Qlik Sense Desktop to select the Team but the list must contain all teams from the 3 Team colomns


      My idea was to combine the 3 colomns in to 1 dimension, but i'm not sure this is the right way.


      An example of what my Excel loks like:


      EmplyeeTeam 1Team 2Team 3



      So the Filter list should contain:





      Thx for you help.