Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

erwinvullers
New Contributor

3 Coloms with the same type of data in 1 Dimension

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.

3 Replies
MVP
MVP

Re: 3 Coloms with the same type of data in 1 Dimension

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

rahulpawarb
Valued Contributor II

Re: 3 Coloms with the same type of data in 1 Dimension

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
Contributor III

Re: 3 Coloms with the same type of data in 1 Dimension

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