Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

anothergreg
New Contributor III

Output unique values from multiple fields into a single dimension

I am trying to look at overall capacity for a team which has the potential to share multiple roles.  Say there is a Project Lead, Business Analyst, Data Analyst, and Developer for each project.  Their allocation % is assigned per role (Project Lead - John Smith, Project Lead Allocation 50%).  I can obviously easily look at the allocation by percent when I create a chart summing the Allocation % by role.  However, I need to do a full-team analysis of overall allocation and I'm having trouble trying to figure out how I can output distinct values from multiple fields in Qlikview.  I have read on how to do unique counts from multiple fields (set analysis to look at first field, then count next field when it is outside range of values for first field, repeat, repeate).  However, I can't seem to find a way to output the actual field value for all columns.

Example:

Project, Project Lead, Project Lead Allocation, Business Analyst, Business Analyst Allocation

A, John Smith, 50, Mike Jones, 25

B, Suzy Queue, 25, Ronald McDonald, 25

C, Jane Doe, 50, John Smith, 50

D, Ronald McDonald, 50, ,

For this, I want to have my table chart return:

John Smith - 100%

Mike Jones - 25%

Suzy Queue - 25%

Ronald McDonald - 75%

Jane Doe - 50%

Is it possible to do this?

1 Solution

Accepted Solutions

Re: Output unique values from multiple fields into a single dimension

Check the attached

Capture.PNG

2 Replies

Re: Output unique values from multiple fields into a single dimension

Check the attached

Capture.PNG

Highlighted
anothergreg
New Contributor III

Re: Output unique values from multiple fields into a single dimension

Ah, multiple loads into a single table.  Thank you!