topic Re: How to show Total for each Dimension in a Straight Table? in QlikView https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734372#M262941 <HTML><HEAD></HEAD><BODY><P>Hi Michael,</P><P></P><P>Go to Dimension limit tab, under this tab at bottom you will find out "Show Total"</P><P></P><P>Hope it will help for you.</P><P></P><P>-- Regards,</P><P>Vishal Waghole</P></BODY></HTML> Wed, 09 Jul 2014 06:23:09 GMT VishalWaghole 2014-07-09T06:23:09Z How to show Total for each Dimension in a Straight Table? https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734366#M262935 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>Is there a way to show a sub-total for each Dimension value in a Straight Table in QlikView?</P><P></P><P>Here is an example where I am trying to do it. Below I want to insert a 'total' type field for each SalesPerson. E.g. Sub-total for Frank, Rob, and Tom. </P><P></P><P><IMG alt="W0SKPaN.jpg" class="jive-image" src="http://i.imgur.com/W0SKPaN.jpg" /></P><P></P><P>I have seen it but I have no idea how to insert it in my data! Any help would be great <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 08 Jul 2014 13:35:52 GMT https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734366#M262935 2014-07-08T13:35:52Z Re: How to show Total for each Dimension in a Straight Table? https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734367#M262936 <HTML><HEAD></HEAD><BODY><P>Hi use pivot table instead.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 08 Jul 2014 13:38:14 GMT https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734367#M262936 ashfaq_haseeb 2014-07-08T13:38:14Z Re: How to show Total for each Dimension in a Straight Table? https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734368#M262937 <HTML><HEAD></HEAD><BODY><P>Transform the table in a pivot table (in the general tab of the table's properties) then in presentation select the field and check show partial sum.</P><P></P><P>Let me knkow</P></BODY></HTML> Tue, 08 Jul 2014 13:38:15 GMT https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734368#M262937 alexandros17 2014-07-08T13:38:15Z Re: How to show Total for each Dimension in a Straight Table? https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734369#M262938 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>Thank you for your replies. I know I can do it in Pivot tables but is it possible to do something similar in a Straight Table?</P><P></P><P>All I want is an extra row underneath each SalesPerson that gives the total. I think I have seen it where it repeats the dimension name (e.g. Frank Roll) and then the last column gives the total for him only.</P></BODY></HTML> Tue, 08 Jul 2014 13:53:33 GMT https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734369#M262938 2014-07-08T13:53:33Z Re: How to show Total for each Dimension in a Straight Table? https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734370#M262939 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>This is not possible is straight table.</P><P></P><P>Regards</P><P>ASHFA</P></BODY></HTML> Tue, 08 Jul 2014 13:56:57 GMT https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734370#M262939 ashfaq_haseeb 2014-07-08T13:56:57Z Re: How to show Total for each Dimension in a Straight Table? https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734371#M262940 <HTML><HEAD></HEAD><BODY><P>If you are using version 11, you can use the 'Show Total' feature on the Dimension Limits tab in the Straight Table property dialogue. <IMG __jive_id="61960" alt="Capture.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/61960_Capture.JPG.jpg" style="width: 620px; height: 358px;" /></P></BODY></HTML> Tue, 08 Jul 2014 14:28:46 GMT https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734371#M262940 lvf 2014-07-08T14:28:46Z Re: How to show Total for each Dimension in a Straight Table? https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734372#M262941 <HTML><HEAD></HEAD><BODY><P>Hi Michael,</P><P></P><P>Go to Dimension limit tab, under this tab at bottom you will find out "Show Total"</P><P></P><P>Hope it will help for you.</P><P></P><P>-- Regards,</P><P>Vishal Waghole</P></BODY></HTML> Wed, 09 Jul 2014 06:23:09 GMT https://community.qlik.com/t5/QlikView/How-to-show-Total-for-each-Dimension-in-a-Straight-Table/m-p/734372#M262941 VishalWaghole 2014-07-09T06:23:09Z