?

[xyz1]

.

[vinieme12]

please post some sample data and expected out

[xyz1]

.

[vinieme12]

what sheet should I refer to? also what is your problem to be solved/ expected output

[Peter_Cammaert]

Please move your discussion to a Qlik Sense forum. Thanks.

[xyz1]

.

[Peter_Cammaert]

Such things can be easily found with the help of the Search box. It's located in the black toolbar at the far right.

QlikCommunity Tip: How to move your discussion thread

[xyz1]

.

[vinieme12]

First Load Employee details and then Crosstable Load ROLE and FTE values, Your data model will look like below

LOAD [Employee Name],

    Location,

    Site,

    Dept,

    [I/E]

FROM

(ooxml, embedded labels, table is [Emp vs Role]);

CrossTable(ROLE,FTE,2)

FACT:

LOAD [Employee Name],

    'Individual'  as FACT_TYPE,

    [Business Relationship (BRM)],

    [Architect / PM],

    Analyst,

    Admin,

    [Support & SME],

    [Project Integrator],

    Specialist,

    Technician,

    [Manager / Team Leader] ,

    Enable

FROM

(ooxml, embedded labels, table is [Emp vs Role]);

CrossTable(ROLE,FTE,2)

temp:

LOAD [Employee Name],

'TEAM' as FACT_TYPE,

    [Alignment & Direction],

    Performance,

    [Sales, Marketing, and Logistics],

    [Industrial, Quality, and Research],

    [Finance, Purchasing, HR, & IT],

    [Web Application Systems],

    [Content Collaboration],

    [Business Intelligence],

    [B2B / EDI],

    [Data Mart Management],

    Testing,

    [Innovation Center],

    [Engineering and Architecture],

    [Infrastructure and Operations],

    OCM,

    [Security and Risk],

    [Client Services],

    [Access Rights],

    Symphony

FROM

(ooxml, embedded labels, table is [Emp vs Team]);

Chart Expression for TEAM TOTAL

=Sum({<FACT_TYPE = {'TEAM'}>}FTE)

Chart Expression for Employee TOTAL

=Sum({<FACT_TYPE = {'Indi*'}>}FTE)

[xyz1]

.