topic Re: How to create a pivot table with multi levels of headers? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-with-multi-levels-of-headers/m-p/117340#M18090 <HTML><HEAD></HEAD><BODY><P>Thank you so much Frank! I appreciate it!</P></BODY></HTML> Wed, 07 Nov 2018 22:06:15 GMT msmichael 2018-11-07T22:06:15Z How to create a pivot table with multi levels of headers? https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-with-multi-levels-of-headers/m-p/117337#M18087 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have raw data in the attached qvw file. </P><P>I need to count how many prodId marked as "Senior" for each team in each region (Global vs EMEA)&nbsp; , and same to Non-Senior ones.</P><P>The final table should look like below, </P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217816_Capture.PNG" style="height: auto;" /></P><P></P><P>How can I get such a table in QV?</P><P></P><P>Thanks,</P><P>Michael</P></BODY></HTML> Wed, 07 Nov 2018 21:01:53 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-with-multi-levels-of-headers/m-p/117337#M18087 msmichael 2018-11-07T21:01:53Z Re: How to create a pivot table with multi levels of headers? https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-with-multi-levels-of-headers/m-p/117338#M18088 <HTML><HEAD></HEAD><BODY><P>see attached file.</P><P><IMG __jive_id="217823" alt="Unbenannt.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217823_Unbenannt.png" style="height: 137px; width: 620px;" /></P><P></P><P>hope this helps</P></BODY></HTML> Wed, 07 Nov 2018 21:33:48 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-with-multi-levels-of-headers/m-p/117338#M18088 Frank_Hartmann 2018-11-07T21:33:48Z Re: How to create a pivot table with multi levels of headers? https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-with-multi-levels-of-headers/m-p/117339#M18089 <HTML><HEAD></HEAD><BODY><P>Hi Michael,</P><P></P><P>I have almost got it, but the totals are broken out by Senior/Non-Senior, see attached.</P></BODY></HTML> Wed, 07 Nov 2018 21:50:22 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-with-multi-levels-of-headers/m-p/117339#M18089 Lisa_P 2018-11-07T21:50:22Z Re: How to create a pivot table with multi levels of headers? https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-with-multi-levels-of-headers/m-p/117340#M18090 <HTML><HEAD></HEAD><BODY><P>Thank you so much Frank! I appreciate it!</P></BODY></HTML> Wed, 07 Nov 2018 22:06:15 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-with-multi-levels-of-headers/m-p/117340#M18090 msmichael 2018-11-07T22:06:15Z Re: How to create a pivot table with multi levels of headers? https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-with-multi-levels-of-headers/m-p/117341#M18091 <HTML><HEAD></HEAD><BODY><P>Hi Lisa,</P><P></P><P>Thank you very much for the solution. I might need this solution also. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 07 Nov 2018 22:55:55 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-pivot-table-with-multi-levels-of-headers/m-p/117341#M18091 msmichael 2018-11-07T22:55:55Z