Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
msmichael
Creator
Creator

How to create a pivot table with multi levels of headers?

Hi,

I have raw data in the attached qvw file.

I need to count how many prodId marked as "Senior" for each team in each region (Global vs EMEA)  , and same to Non-Senior ones.

The final table should look like below,

Capture.PNG

How can I get such a table in QV?

Thanks,

Michael

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

see attached file.

Unbenannt.png

hope this helps

View solution in original post

4 Replies
Frank_Hartmann
Master II
Master II

see attached file.

Unbenannt.png

hope this helps

View solution in original post

Lisa_P
Employee
Employee

Hi Michael,

I have almost got it, but the totals are broken out by Senior/Non-Senior, see attached.

msmichael
Creator
Creator
Author

Thank you so much Frank! I appreciate it!

msmichael
Creator
Creator
Author

Hi Lisa,

Thank you very much for the solution. I might need this solution also.