topic Re: horizontal dimension total by row in QlikView https://community.qlik.com/t5/QlikView/horizontal-dimension-total-by-row/m-p/97632#M15657 <HTML><HEAD></HEAD><BODY><P>Thank you for your help Anil. Maybe I don't explain very well but what I need is make a ONE total. For example in your QVW file this should be TOTAL (total exp1 + total exp2) and not 2 columns as total for each expression.</P></BODY></HTML> Mon, 24 Sep 2018 13:03:10 GMT Anonymous 2018-09-24T13:03:10Z horizontal dimension total by row https://community.qlik.com/t5/QlikView/horizontal-dimension-total-by-row/m-p/97630#M15655 <HTML><HEAD></HEAD><BODY><P>Hi Community.</P><P></P><P>I have this pivot table with a horizontal dimension and 2 expressions, what I need is to show ONE grand total for the both expressions (Only one total for both). But in qlikview i can only show partial sums and the 2 expressions show me 2 totals.</P><P></P><P>Any help would be very helpful</P><P></P><P>Thank you.</P><P></P><P>P.D : This is a photo of my actual pivot table. </P><P><IMG alt="kxa5ks" class="jive-image image-1" src="https://prnt.sc/kxa5ks" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Sat, 22 Sep 2018 02:35:19 GMT https://community.qlik.com/t5/QlikView/horizontal-dimension-total-by-row/m-p/97630#M15655 Anonymous 2018-09-22T02:35:19Z Re: horizontal dimension total by row https://community.qlik.com/t5/QlikView/horizontal-dimension-total-by-row/m-p/97631#M15656 <HTML><HEAD></HEAD><BODY><P>This is Doable. Check if that helps. Test If attached application helps?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214212_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Sat, 22 Sep 2018 06:02:25 GMT https://community.qlik.com/t5/QlikView/horizontal-dimension-total-by-row/m-p/97631#M15656 Anil_Babu_Samineni 2018-09-22T06:02:25Z Re: horizontal dimension total by row https://community.qlik.com/t5/QlikView/horizontal-dimension-total-by-row/m-p/97632#M15657 <HTML><HEAD></HEAD><BODY><P>Thank you for your help Anil. Maybe I don't explain very well but what I need is make a ONE total. For example in your QVW file this should be TOTAL (total exp1 + total exp2) and not 2 columns as total for each expression.</P></BODY></HTML> Mon, 24 Sep 2018 13:03:10 GMT https://community.qlik.com/t5/QlikView/horizontal-dimension-total-by-row/m-p/97632#M15657 Anonymous 2018-09-24T13:03:10Z Re: horizontal dimension total by row https://community.qlik.com/t5/QlikView/horizontal-dimension-total-by-row/m-p/97633#M15658 <HTML><HEAD></HEAD><BODY><P>PFA, There is no way straight forward. The way what I've done is the Work around..</P><P><IMG alt="capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/214350_capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 25 Sep 2018 03:19:40 GMT https://community.qlik.com/t5/QlikView/horizontal-dimension-total-by-row/m-p/97633#M15658 Anil_Babu_Samineni 2018-09-25T03:19:40Z Re: horizontal dimension total by row https://community.qlik.com/t5/QlikView/horizontal-dimension-total-by-row/m-p/97634#M15659 <HTML><HEAD></HEAD><BODY><P>Did you get a chance to look?</P></BODY></HTML> Mon, 08 Oct 2018 13:55:22 GMT https://community.qlik.com/t5/QlikView/horizontal-dimension-total-by-row/m-p/97634#M15659 Anil_Babu_Samineni 2018-10-08T13:55:22Z