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
      JackDPABackupSystems
      JoseDPA
      JohnnyBackupSystems

       

       

      So the Filter list should contain:

      DPA

      Backup

      Systems

       

      Thx for you help.