topic Re: Table box or Straight Table or Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Table-box-or-Straight-Table-or-Pivot-Table/m-p/455828#M1159551 <HTML><HEAD></HEAD><BODY><P>I dont want to use any expressions...bcos I want only two columns.....</P></BODY></HTML> Wed, 21 Nov 2012 15:43:57 GMT 2012-11-21T15:43:57Z Table box or Straight Table or Pivot Table https://community.qlik.com/t5/QlikView/Table-box-or-Straight-Table-or-Pivot-Table/m-p/455826#M1159549 <HTML><HEAD></HEAD><BODY><P>I have 2 fields(Dimensions) with 40K rows....I populated them in the table box and now I want a total row in the table box either on top or bottom.....I tried using straight and pivot table but if I give an expression I am getting 3rd coloum to show total....I need only 2 colums and total on top or bottom in that columns...please help me...</P></BODY></HTML> Wed, 21 Nov 2012 14:51:35 GMT https://community.qlik.com/t5/QlikView/Table-box-or-Straight-Table-or-Pivot-Table/m-p/455826#M1159549 2012-11-21T14:51:35Z Re: Table box or Straight Table or Pivot Table https://community.qlik.com/t5/QlikView/Table-box-or-Straight-Table-or-Pivot-Table/m-p/455827#M1159550 <HTML><HEAD></HEAD><BODY><P>You need to enable partial sums of the dimension in a pivot table to show the totals. You can do this on the Presentation tab of the properties screen. In a straight table your expression must be such that it can be aggregated. It may be necessary to use the aggr function to achieve this. And of course the Total Mode needs to be set to something other than No Totals.</P></BODY></HTML> Wed, 21 Nov 2012 15:13:28 GMT https://community.qlik.com/t5/QlikView/Table-box-or-Straight-Table-or-Pivot-Table/m-p/455827#M1159550 Gysbert_Wassenaar 2012-11-21T15:13:28Z Re: Table box or Straight Table or Pivot Table https://community.qlik.com/t5/QlikView/Table-box-or-Straight-Table-or-Pivot-Table/m-p/455828#M1159551 <HTML><HEAD></HEAD><BODY><P>I dont want to use any expressions...bcos I want only two columns.....</P></BODY></HTML> Wed, 21 Nov 2012 15:43:57 GMT https://community.qlik.com/t5/QlikView/Table-box-or-Straight-Table-or-Pivot-Table/m-p/455828#M1159551 2012-11-21T15:43:57Z Re: Table box or Straight Table or Pivot Table https://community.qlik.com/t5/QlikView/Table-box-or-Straight-Table-or-Pivot-Table/m-p/455829#M1159552 <HTML><HEAD></HEAD><BODY><P>Then you can only use a table box and have no totals. You can't have it both ways. Only expressions can be used to calculate totals.</P></BODY></HTML> Wed, 21 Nov 2012 15:50:42 GMT https://community.qlik.com/t5/QlikView/Table-box-or-Straight-Table-or-Pivot-Table/m-p/455829#M1159552 Gysbert_Wassenaar 2012-11-21T15:50:42Z Re: Table box or Straight Table or Pivot Table https://community.qlik.com/t5/QlikView/Table-box-or-Straight-Table-or-Pivot-Table/m-p/455830#M1159553 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert....</P></BODY></HTML> Wed, 21 Nov 2012 15:56:56 GMT https://community.qlik.com/t5/QlikView/Table-box-or-Straight-Table-or-Pivot-Table/m-p/455830#M1159553 2012-11-21T15:56:56Z