topic Row level total - pivot in QlikView https://community.qlik.com/t5/QlikView/Row-level-total-pivot/m-p/1421829#M428826 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have a pivot table that looks something like this</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; compliant&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; in office&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; no time booked&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TOTAL</P><P><SPAN style="font-size: 13.3333px;">BU</SPAN></P><P><SPAN style="font-size: 13.3333px;">------------------------------------------------------------------------------------------------------<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">BU1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24</SPAN></P><P><SPAN style="font-size: 13.3333px;">BU2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13</SPAN></P><P><SPAN style="font-size: 13.3333px;">BU3</SPAN><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</SPAN></P><P></P><P>The BU dimension is straight forward. However the second column in the pivot is an aggregation: </P><P>Aggr(FirstSortedValue(COMPLIANCE_DESC , -PRIORITY), EMP_ID)</P><P></P><P>Now, I want the % of compliance , not just the headcount. I tried adding Count(Total EMP_ID) to the expression, however the results were 49 (24+13+12) in every cell.</P><P></P><P>How will i get the total value per row? 24 in the first, 13 in the second...</P><P></P><P></P><P>Thanks</P><P>Anagha</P></BODY></HTML> Mon, 18 Dec 2017 13:41:57 GMT anagharao 2017-12-18T13:41:57Z Row level total - pivot https://community.qlik.com/t5/QlikView/Row-level-total-pivot/m-p/1421829#M428826 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have a pivot table that looks something like this</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; compliant&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; in office&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; no time booked&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TOTAL</P><P><SPAN style="font-size: 13.3333px;">BU</SPAN></P><P><SPAN style="font-size: 13.3333px;">------------------------------------------------------------------------------------------------------<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">BU1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24</SPAN></P><P><SPAN style="font-size: 13.3333px;">BU2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13</SPAN></P><P><SPAN style="font-size: 13.3333px;">BU3</SPAN><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</SPAN></P><P></P><P>The BU dimension is straight forward. However the second column in the pivot is an aggregation: </P><P>Aggr(FirstSortedValue(COMPLIANCE_DESC , -PRIORITY), EMP_ID)</P><P></P><P>Now, I want the % of compliance , not just the headcount. I tried adding Count(Total EMP_ID) to the expression, however the results were 49 (24+13+12) in every cell.</P><P></P><P>How will i get the total value per row? 24 in the first, 13 in the second...</P><P></P><P></P><P>Thanks</P><P>Anagha</P></BODY></HTML> Mon, 18 Dec 2017 13:41:57 GMT https://community.qlik.com/t5/QlikView/Row-level-total-pivot/m-p/1421829#M428826 anagharao 2017-12-18T13:41:57Z Re: Row level total - pivot https://community.qlik.com/t5/QlikView/Row-level-total-pivot/m-p/1421830#M428827 <HTML><HEAD></HEAD><BODY><P>If you use Partial Sum option checked this will automatic do and display </P></BODY></HTML> Mon, 18 Dec 2017 13:43:43 GMT https://community.qlik.com/t5/QlikView/Row-level-total-pivot/m-p/1421830#M428827 Anil_Babu_Samineni 2017-12-18T13:43:43Z Re: Row level total - pivot https://community.qlik.com/t5/QlikView/Row-level-total-pivot/m-p/1421831#M428828 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Count(TOTAL<SPAN style="color: #ff0000;"> &lt;BU&gt;</SPAN> EMP_ID)</STRONG></SPAN></P></BODY></HTML> Mon, 18 Dec 2017 13:44:59 GMT https://community.qlik.com/t5/QlikView/Row-level-total-pivot/m-p/1421831#M428828 sunny_talwar 2017-12-18T13:44:59Z Re: Row level total - pivot https://community.qlik.com/t5/QlikView/Row-level-total-pivot/m-p/1421832#M428829 <HTML><HEAD></HEAD><BODY><P>Thank you !</P></BODY></HTML> Mon, 18 Dec 2017 13:51:03 GMT https://community.qlik.com/t5/QlikView/Row-level-total-pivot/m-p/1421832#M428829 anagharao 2017-12-18T13:51:03Z Re: Row level total - pivot https://community.qlik.com/t5/QlikView/Row-level-total-pivot/m-p/1421833#M428830 <HTML><HEAD></HEAD><BODY><P>Also, what if it is a drilldown group and not just BU?</P></BODY></HTML> Mon, 18 Dec 2017 13:51:36 GMT https://community.qlik.com/t5/QlikView/Row-level-total-pivot/m-p/1421833#M428830 anagharao 2017-12-18T13:51:36Z Re: Row level total - pivot https://community.qlik.com/t5/QlikView/Row-level-total-pivot/m-p/1421834#M428831 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Count(TOTAL<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;"> &lt;$(='[' &amp; GetCurrentField([GroupName]) &amp; ']')&gt;</SPAN> EMP_ID)</STRONG></P></BODY></HTML> Mon, 18 Dec 2017 13:54:34 GMT https://community.qlik.com/t5/QlikView/Row-level-total-pivot/m-p/1421834#M428831 sunny_talwar 2017-12-18T13:54:34Z