3 Coloms with the same type of data in 1 Dimension

[erwinvullers]

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:

Emplyee	Team 1	Team 2	Team 3
Jack	DPA	Backup	Systems
Jose	DPA
Johnny	Backup	Systems

So the Filter list should contain:

DPA

Backup

Systems

Thx for you help.

[sunny_talwar]

May be use The Crosstable Load to transform your data from three teams into one column

[rahulpawarb]

Hello Erwin,

As a workaround you can refer below sample script:

Employees:
LOAD Emplyee, 
     [Team 1], 
     [Team 2], 
     [Team 3]
FROM
[https://community.qlik.com/thread/267565?sr=stream&ru=171708]
(html, codepage is 1252, embedded labels, table is @1);

TeamList:
LOAD Distinct TeamName;
LOAD [Team 1] AS TeamName
Resident Employees
Where Len(TRIM([Team 1])) > 0;
Concatenate
LOAD [Team 2] AS TeamName
Resident Employees
Where Len(TRIM([Team 2])) > 0;
Concatenate
LOAD [Team 3] AS TeamName
Resident Employees
Where Len(TRIM([Team 3])) > 0;

Hope this will help.

P.S.: Provided script is QlikView compliant; please make necessary changes to run the same on Qlik Sense.

Regards!

Rahul

[dberkesacn]

I also suggest what Sunny recommended, use the Crosstable script see below:

Crosstable(Teams,Type)

Load

     Emplyee,

     "Team 1",

     "Team 2",

     "Team 3"

From Source;

Daniel