Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be use The Crosstable Load to transform your data from three teams into one column
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
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