topic Re: Sum/total column in PIVOT TABLE in QlikView https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308519#M407034 <HTML><HEAD></HEAD><BODY><P>Have you tried enabling Partial Sum for your second dimension like:</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164229_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 22 May 2017 08:58:46 GMT tresB 2017-05-22T08:58:46Z Sum/total column in PIVOT TABLE https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308514#M407029 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>Can somebody help me how can I add TOTAL column in PIVOT Table.</P><P></P><P>I have table:</P><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hours (1.5.2017)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hours(2.5.2017) ....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>10&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P><P>12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&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&nbsp;&nbsp;&nbsp;&nbsp; </P><P>17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&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; 5&nbsp;&nbsp;&nbsp;&nbsp; </P><P>19&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&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; 6</P><P>....</P><P></P><P>And I need table:</P><P style="font-size: 13.3333px;">I have table:</P><P style="font-size: 13.3333px;">ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hours (1.5.2017)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hours(2.5.2017) ....&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>TOTAL </STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P style="font-size: 13.3333px;">10&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&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; <STRONG> 13</STRONG></P><P style="font-size: 13.3333px;">12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&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&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; <STRONG>20</STRONG></P><P style="font-size: 13.3333px;">17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&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; 5&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; <STRONG>16</STRONG>&nbsp;&nbsp; </P><P style="font-size: 13.3333px;">19&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&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; 6&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; <STRONG style="color: #575757;">19</STRONG> </P><P style="font-size: 13.3333px;">....</P><P></P><P>Thank you for answer my question. </P></BODY></HTML> Mon, 22 May 2017 08:28:40 GMT https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308514#M407029 jozisvk11 2017-05-22T08:28:40Z Re: Sum/total column in PIVOT TABLE https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308515#M407030 <HTML><HEAD></HEAD><BODY><P>Why can't partial Sum from presentation Tab</P><P>Or</P><P><STRONG>Sum(TOTAL &lt;Hours&gt; Sales)</STRONG></P></BODY></HTML> Mon, 22 May 2017 08:32:57 GMT https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308515#M407030 Anil_Babu_Samineni 2017-05-22T08:32:57Z Re: Sum/total column in PIVOT TABLE https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308516#M407031 <HTML><HEAD></HEAD><BODY><P>Are you expecting like this </P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164218_Untitled.png" style="height: auto;" /></P></BODY></HTML> Mon, 22 May 2017 08:38:39 GMT https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308516#M407031 qlikview979 2017-05-22T08:38:39Z Re: Sum/total column in PIVOT TABLE https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308517#M407032 <HTML><HEAD></HEAD><BODY><P>PFA,</P></BODY></HTML> Mon, 22 May 2017 08:41:34 GMT https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308517#M407032 qlikview979 2017-05-22T08:41:34Z Re: Sum/total column in PIVOT TABLE https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308518#M407033 <HTML><HEAD></HEAD><BODY><P>Yes, but I have only one column in expression.(SET analyse).&nbsp; The amount of columns is not the same, that changing according to date. </P></BODY></HTML> Mon, 22 May 2017 08:45:14 GMT https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308518#M407033 jozisvk11 2017-05-22T08:45:14Z Re: Sum/total column in PIVOT TABLE https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308519#M407034 <HTML><HEAD></HEAD><BODY><P>Have you tried enabling Partial Sum for your second dimension like:</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164229_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 22 May 2017 08:58:46 GMT https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308519#M407034 tresB 2017-05-22T08:58:46Z Re: Sum/total column in PIVOT TABLE https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308520#M407035 <HTML><HEAD></HEAD><BODY><P>Here my Dimensions are</P><P></P><P>1)ID,</P><P>2)Hours(1.5.2017)</P><P>3)Hours(2.5.2017)</P><P></P><P>Expression:-sum(<SPAN style="font-size: 13.3333px;">Hours(1.5.2017))+sum(<SPAN style="font-size: 13.3333px;">Hours(1.5.2017))</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164231_Untitled.png" style="height: auto;" /><BR /></SPAN></P></BODY></HTML> Mon, 22 May 2017 08:58:54 GMT https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308520#M407035 qlikview979 2017-05-22T08:58:54Z Re: Sum/total column in PIVOT TABLE https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308521#M407036 <HTML><HEAD></HEAD><BODY><P>partial sum is only for dimension. </P></BODY></HTML> Mon, 22 May 2017 09:08:52 GMT https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308521#M407036 jozisvk11 2017-05-22T09:08:52Z Re: Sum/total column in PIVOT TABLE https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308522#M407037 <HTML><HEAD></HEAD><BODY><P>Could you post your sample qvw? <A href="https://community.qlik.com/docs/DOC-1290">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Mon, 22 May 2017 09:14:26 GMT https://community.qlik.com/t5/QlikView/Sum-total-column-in-PIVOT-TABLE/m-p/1308522#M407037 tresB 2017-05-22T09:14:26Z