Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
joshdabbott
New Contributor II

Pivot Table - Concatenate multiple columns into 1 column

Hello!

I have a situation where I have a manager hierarchy and I want to get employee totals for each level, but I want 1 column per manager (be it the manager a top level manager, or a lowest level manager).  I'm attaching an example, please note, in the example, I have a 'City' field (this is only an example but I want to demonstrate with this that I have multiple dimensional values like city that users can select, so I don't see a good way of building a table in the script with the counts of each level, because then the filters wouldn't work).  Here is what I can get using a pivot table:

But what I really want is:

Thank you for any help you can give me!

Josh

1 Solution

Accepted Solutions

Re: Pivot Table - Concatenate multiple columns into 1 column

Add a new table in the script like this

Dim:

LOAD * INLINE [

    Dim

    1

    2

    3

];

and now create a chart with these

Dimension

=Pick(Dim, Mgr1, Mgr2, Mgr3)

Expression

=sum(TotalEmp)

Capture.PNG

View solution in original post

2 Replies

Re: Pivot Table - Concatenate multiple columns into 1 column

Add a new table in the script like this

Dim:

LOAD * INLINE [

    Dim

    1

    2

    3

];

and now create a chart with these

Dimension

=Pick(Dim, Mgr1, Mgr2, Mgr3)

Expression

=sum(TotalEmp)

Capture.PNG

View solution in original post

joshdabbott
New Contributor II

Re: Pivot Table - Concatenate multiple columns into 1 column

Yes, that is perfect.  Thank you!