topic Re: Subtotals for colums and ROWS too! in QlikView https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681096#M542179 <HTML><HEAD></HEAD><BODY><P>Can you attach application here? </P></BODY></HTML> Sun, 15 Jun 2014 21:28:46 GMT bgerchikov 2014-06-15T21:28:46Z Subtotals for colums and ROWS too! https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681089#M542172 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I'm trying to display subtotals for the different dimensions. I have flagged "Show Subtotals", but they don't appear (see attachment). Then I also need to add a column at the end of the table (see again picture) where there are rows' subtotals (like an excel pivot table). Is there a way to do it?</P></BODY></HTML> Sun, 15 Jun 2014 20:59:27 GMT https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681089#M542172 2014-06-15T20:59:27Z Re: Subtotals for colums and ROWS too! https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681090#M542173 <HTML><HEAD></HEAD><BODY><P>Hi Irene,</P><P></P><P>you should check "Show Partial Sums" for every dimension you want to be totaled. not just for Dep.</P><P></P><P>Hope it will help.</P></BODY></HTML> Sun, 15 Jun 2014 21:12:48 GMT https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681090#M542173 bgerchikov 2014-06-15T21:12:48Z Re: Subtotals for colums and ROWS too! https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681091#M542174 <HTML><HEAD></HEAD><BODY><P>I have already flagged that parameter for each dimension, but I still cannot visualize the subtotal for the dimension Dep!</P></BODY></HTML> Sun, 15 Jun 2014 21:19:33 GMT https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681091#M542174 2014-06-15T21:19:33Z Re: Subtotals for colums and ROWS too! https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681092#M542175 <HTML><HEAD></HEAD><BODY><P>Hi Irene,</P><P>You should mark each column you want to be summarized</P></BODY></HTML> Sun, 15 Jun 2014 21:23:29 GMT https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681092#M542175 Clever_Anjos 2014-06-15T21:23:29Z Re: Re: Subtotals for colums and ROWS too! https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681093#M542176 <HTML><HEAD></HEAD><BODY><P>PFA</P><P><IMG alt="Capturar.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/60610_Capturar.PNG.png" style="width: 620px; height: 184px;" /></P></BODY></HTML> Sun, 15 Jun 2014 21:25:01 GMT https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681093#M542176 Clever_Anjos 2014-06-15T21:25:01Z Re: Subtotals for colums and ROWS too! https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681094#M542177 <HTML><HEAD></HEAD><BODY><P>I have already done it! but it doesn't work...I don't see the subtotal for Dep... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Sun, 15 Jun 2014 21:25:20 GMT https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681094#M542177 2014-06-15T21:25:20Z Re: Re: Subtotals for colums and ROWS too! https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681095#M542178 <HTML><HEAD></HEAD><BODY><P>Please post your expression here, let me check</P></BODY></HTML> Sun, 15 Jun 2014 21:27:45 GMT https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681095#M542178 Clever_Anjos 2014-06-15T21:27:45Z Re: Subtotals for colums and ROWS too! https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681096#M542179 <HTML><HEAD></HEAD><BODY><P>Can you attach application here? </P></BODY></HTML> Sun, 15 Jun 2014 21:28:46 GMT https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681096#M542179 bgerchikov 2014-06-15T21:28:46Z Re: Subtotals for colums and ROWS too! https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681097#M542180 <HTML><HEAD></HEAD><BODY><P>here is the file and the chart is already open...it is called "Giacenze"..thanks</P></BODY></HTML> Sun, 15 Jun 2014 21:32:33 GMT https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681097#M542180 2014-06-15T21:32:33Z Re: Subtotals for colums and ROWS too! https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681098#M542182 <HTML><HEAD></HEAD><BODY><P>Use: sum([ProgDepQta Giacenza Attuale])</P><P>Expressions should have always an aggregation function (SUM,AVG,ONLY,etc)</P></BODY></HTML> Sun, 15 Jun 2014 21:41:33 GMT https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681098#M542182 Clever_Anjos 2014-06-15T21:41:33Z Re: Subtotals for colums and ROWS too! https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681099#M542184 <HTML><HEAD></HEAD><BODY><P>thank you <A href="https://community.qlik.com/qlik-users/21667">Clever Anjos</A>!!! I was getting mad with the flag...I could imagine I need the sum for each dimension...</P></BODY></HTML> Sun, 15 Jun 2014 21:46:59 GMT https://community.qlik.com/t5/QlikView/Subtotals-for-colums-and-ROWS-too/m-p/681099#M542184 2014-06-15T21:46:59Z